Dax error

Question

I need your help with that calculation , firstly I used dax to divid CY by LY to yield (Value Divide) , as shown belowthen used another dax to minus value divide from 1 (value divide - 1) as shown belowbut the rewult was not good , it minus all rows not only the filtered one and yield many rows with -100%I think there is a mistake in my dax (value divide -1) what should I edit?&nbsp;

antrikshsharma · Answer

Anonymous&nbsp; Use this&nbsp;
=
IF ( [Value CY] &lt;&gt; BLANK () &amp;&amp; [Value LY] &lt;&gt; BLANK (), [Values Divide] )

&nbsp;

daxer-almighty · Answer

&nbsp;[Brand PPG] =
var __division = [Value Divide]
return
    IF( __division, __division - 1 )&nbsp;The above formula says: If __division is BLANK or 0, do not display (__division - 1). This works because 0 and BLANK() are treated as False when used in a bool context.&nbsp;If you want to get max speed from the calculation, you'd do this:&nbsp;[Brand PPG] =
var __division = [Value Divide]
var __shouldCalc = DIVIDE( __division, __division )
return
    __shouldCalc * (__division - 1)&nbsp;The above does not use IF and hence has the potential to only use Storage Engine, hence maximum speed.

Forum Discussion

Dax error

Related content

Dax error

Dax

DAX

error message

DAX Behavior