Reply
Frequent Visitor
Posts: 8
Registered: ‎06-22-2017
Accepted Solution

IF condition in Grand Total

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 


Accepted Solutions
Member
Posts: 53
Registered: ‎06-03-2017

Re: IF condition in Grand Total

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)

View solution in original post


All Replies
Member
Posts: 53
Registered: ‎06-03-2017

Re: IF condition in Grand Total

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)