Kindly advice on DAX formulae for calculating divide and subtract together
I have Column A, B, C Formulae for calculating % as follow Colum A / (Column B-C) OR A/(B-C) Any advice on how to convert this into DAX formulae will be highly appreciated.
Asked
Active
Viewed 4,017 times
0
-
For subtraction, I was thinking this Dax formula: Calculate (Sum(column[B]))-Calculate (Sum(column[C])) but I need to combine this with column A – SQLfun Apr 24 '18 at 19:56
-
Is this for a measure or for a calculated column? What you write will be different in these cases. – Alexis Olson Apr 24 '18 at 20:37
-
Getting an error please see attac – SQLfun Apr 25 '18 at 09:26
-
C A B Discount DAX Fomulae in % 49 33 30 C /(Column A- Culumn B) – SQLfun Apr 25 '18 at 09:27
1 Answers
0
I prefer to use the DIVIDE function instead of just regular division, because this handles scenarios where the denominator is null or zero, so I would use the following for your problem (when the denominator is zero, the output of this is 0):
MeasureName:=DIVIDE(Column A, Column B - Column C, 0)
tysonwright
- 1,525
- 1
- 9
- 19
-
Wow that’s really great much appreciated for prompt response @ Tysonwright – SQLfun Apr 24 '18 at 20:03