Forum Discussion
Wrong Subtotal when using Variable
Hello, I get a wrong result in my subtotal when I utilize a variable. I use months as a filter. I cannot see the connection. Diff Actual Billing - Budget =
Var DiffActualtoBudget = [To...
Hi v-frfei-msft
In some measures, I get the same result when I use the VAR expression (as expected ) and in some, I don't (in the subtotal for example).
Perhaps it has to do with the SUMX ...
Why would you wrap your simple SUM with a CALCULATE? What is the benefit of that?
Regards,
Tamir
Hi Anonymous,
Could you please tell me what are your measures of [Total Actual Billing] and [Total Budget] and kindly share your sample data if possible?
Regards,
Frank