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

A,B and C are a measures sum of several values.

 

for example:
A= CALCULATE ( SUM( Table1[A1] ); FILTER ( DimDates;DimDates[Date] ) )

 

If I add a tabel column I don't think obtain Grand Total a correct result..

 

 

thanks in advance 

Franco

 

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

fpavan76

 

Hi Franco,

 

We need a workaround here. In my example, we can see it works.

 

2Measure =
IF (
    HASONEVALUE ( 'Date'[Calendar Year] ) = FALSE (),
    SUMX ( 'Date', [Sales Amount] ),
    [Sales Amount]
)

 

 

 

 

 

 

 

 

 

 

 

Maybe your formula is something like this:

2Measure =
IF (
    HASONEVALUE ( 'Table1'[Column_in_table] ) = FALSE (),
    SUMX ( 'Table1', [Measure] ),
    [Measure]
)

 

Best Regards!

Dale