Forum Discussion

Post Prodigy

5 years ago

Solved

Wrong Total on max

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

Tips and Tricks

Anonymous
5 years ago
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
Wrong Total on max.pbix39 KB

3 Replies

Anonymous
Not applicable
5 years ago
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
Wrong Total on max.pbix39 KB
- Analitika
  Post Prodigy
  5 years ago
  but it wrong too lookk 12407 4+9=13 but your total is 9 this is wrong
  - Anonymous
    Not applicable
    5 years ago
    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

Related content