Wrong Total on max

[Analitika]

Measure1 = 

MAXX(DISTINCT('T1'[sas_kod]),CALCULATE(max('T1'[TurnCredNC])-max('T1'[TurnDebNC])))

Measure2 = 

SUMX(VALUES('T1'[sas_kod]),[Measure1 ])

So Measure2 give wrong Columns total also like Measure1, but should just Sum all results from Measure2

[Anonymous · Accepted solution]

Hi @Analitika ,

Please change the formula of your measures [Measure1] and [Measure2] as below, you can find the details in the attachment.

Measure1 = CALCULATE ( SUM ( 'T1'[TurnCredNC] ) ) - CALCULATE ( SUM ( 'T1'[TurnDebNC] ) )

Measure2 = SUMX ( VALUES ( 'T1'[sas_kod] ), MAXX ( VALUES ( 'T1'[Date] ), [Measure1] ) )

If the above one is not what you want, please provide more details on your requirement. Thank you.

Best Regards

[Analitika]

but it wrong too lookk 12407  4+9=13 but your total is 9 this is wrong

[Anonymous]

Hi @Analitika ,

Please update the formula of Measure2 as below:

Measure2 = SUMX(GROUPBY('T1','T1'[sas_kod],'T1'[Date]),[Measure1])

If the above one still not correct, please provide your expected result base on my sample data. Thank you.

Best Regards