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
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft 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