Forum Discussion

fpavan76's avatar
fpavan76
Regular Visitor
9 years ago

Calculate Grand Total with Conditional

Hi to all, I need a suggest about a measure to calculate grand total with particular condition. I have 3 columns A, B and C I want insert this condition: IF A+B > C then A+B else 0 This formula ...
Need Help
fpavan76's avatar
fpavan76
Regular Visitor
9 years ago

Hi MFelix

 

I've try use your suggestion but I don't know because it work incorrectly.

 

 

 

In attachment you should see the Measure to calculate A,B and C (i.e. Measure A),
Measure with condition,
measure without condition.

 

If you observe the misure with condition the Grand Total is 28, not 30..


Thanks in advance.

Franco

 

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi fpavan76,

 

Could you please tell me if my solution works?

 

Best Regards!

Dale

  • fpavan76's avatar
    fpavan76
    Regular Visitor
    9 years ago

    Hi v-jiascu-msft

    I've tried to use your solution but return a non-correct results.
    I think it's depend by the model because I've a facts table, many dimension tables and a dates table.

     

    I don't have any idea to solve this issue ..

     

    thanks,

    Franco