Forum Discussion
Help with DAX calculation( addition and division)
http://www.sqlbi.com/ AND http://www.powerpivotpro.com/
Both are great AND both have published great books!
I had been searching for a similar solution for about a week now. and had found that division was only returning the numerator in anything i was trying.
=DIVIDE(numerator, denominator, optional case) this lead me to believe that optional case was in fact optional and that it wasnt necessary. But to do a proper calculation without the divide by zero case.. it needs that ,0 option.
with scalars not of the data set i tried =DIVIDE(25,33) hoping that it would yield .75 and i was getting it to yield the numerator in return. I had tried with sums of the columns i was using etc. but i believe the appropriate thing here is that ,0 optional... if you do not need anything else in your operands that you should include the ,0 in the division formula.... as such = [numerator] / [denominator] will not yield the same result as =DIVIDE([numerator], [denominator],0)
so many SUM and SUMX and COUNTX and CALCULATE custom formulas wasted - it was a learning process though.
Thanks again for posing the question and providing the answer... now on to more difficult tasks.