Forum Discussion

Anonymous

Not applicable

7 years ago

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...

Community Support

7 years ago

Hi Anonymous,

Could you please share your pbix to me so that I can help with that?

Regards,

Frank

Anonymous
Not applicable
7 years ago
Hi v-frfei-msft

Unfortunately, I cannot share that pbix file.

Can you see clearly the formulas or do I need write it in the thread?

Regards,
Tamir
- v-frfei-msft
  Community Support
  7 years ago
  Hi Anonymous,
  
  I made one sample here, However that the measure seemed worked well in my side. Could you please share your sample data to me if possible? And what are the formulas of your [Total Actual Billing] and [Total Budget]?
  Attached the pbix for your reference.
  
  https://www.dropbox.com/s/2rl06yza5z6opmg/Wrong%20Subtotal%20when%20using%20Variable.pbix?dl=0
  
  Regards,
  Frank
  - Anonymous
    Not applicable
    7 years ago
    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