IF condition in Grand Total

[fpavan76]

Hi to all,

i have a question 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 work correclty in the table rows but not work in Grand Total .

May you help me to solved this issue?

Thanks in advance

Franco 

[Anonymous · Accepted solution]

You can create a new measure (not column) using DAX as follows:

Measure = IF(SUM(Data[A])+SUM(Data[B])>SUM(Data[C]);SUM(Data[A])+SUM(Data[B]);0)