Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm currently writing a DAX that will get the percentage between the total and the filtered amount.
This is what I have so far:
CALCULATE function can not change the value of variables
Create a measure of ABC instead of variables and try again. Once a measure was calculated and assigned to variables, the value was static, CALCULATE function can not change the value of variables just like Daniel mentioned.
Still the same behavior. I already created a measure instead of a variable.
Div1 =
(CALCULATE([ABC], REMOVEFILTERS('_sp-Total Invoiced to Date - Current Month')))