Forum Discussion

Analitika's avatar
Analitika
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 a...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    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

Anonymous's avatar
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

  • Analitika's avatar
    Analitika
    Post Prodigy
    5 years ago

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

    • Anonymous's avatar
      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