Careful with DAX variables. Variables defined OUTSIDE of expressions have already been computed. If you wish to modify the value of the variable with CALCULATE, you have to define the variable INSIDE of the expression. See below for an example.
Careful with DAX variables. Variables defined OUTSIDE of expressions have already been computed. If you wish to modify the value of the variable with CALCULATE, you have to define the variable INSIDE of the expression. See below for an example.