Calculate total of Measures

[Anonymous]

Hi All,

I am trying to calculate the total of measure that is created using two other measures. But I am not able to achieve it.

The difference column is calculated by subtracting Previous month values from Total CWIP values for each row. I am getting correct difference but the total should have -ve. Instead I am getting +ve.

I am suspecting that instead of total of Difference column it is subtracting Total of Previous Month from Total of Total CWIP column.

[v-gizhi-msft]

Hi,

Please try this:

Measure = SUMX ( GROUPBY ( 'Table', 'Table'[Year], 'Table'[Month] ), [Difference] )

Hope this helps.

Best Regards,

Giotto

[Mariusz · Accepted solution]

Hi @Anonymous 

You can use 

Measure = 
SUMX(
    SUMMARIZE(
        'Table',
        'Table'[Year],
        'Table'[Month]
    ),
    [Difference]
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Thanks Mariusz.

It worked