topic Re: Measure : Calculate does not select right MAX ( date) in DAX Commands and Tips

Measure : Calculate does not select right MAX ( date)

HaiVN — Thu, 08 Aug 2024 13:04:33 GMT

Dear all,
I need your help on my DAX
I write a measure:
----
Total persons =
Var
Total = CALCULATE(
SUM('data'[value]),
'data'[Date]=MAX('data'[Date]))
return
if(Total>4, Total, "< 5")

------
'data'[Date] has 4 dates:

4. mars 2024
11. mars 2024
18. mars 2024
14. mai 2024

10. juni 2024

My problem is the measure choose " 4. mars 2024" for calculation , not "10. juni 2024" as I want! Can you help my to clarify what is problem with my measure ?

Thank you!

Re: Measure : Calculate does not select right MAX ( date)

aduguid — Thu, 08 Aug 2024 13:10:39 GMT

Try this measure

Total persons = VAR MaxDate = MAXX(ALL('data'[Date]), 'data'[Date]) VAR Total = CALCULATE( SUM('data'[value]), 'data'[Date] = MaxDate ) RETURN IF(Total > 4, Total, "< 5")

Re: Measure : Calculate does not select right MAX ( date)

HaiVN — Thu, 08 Aug 2024 13:35:39 GMT

aduguid Thanks for your help, but it does not work when I try the measure as you suggest.
When I try to show the maxdate only i a card , ut shows correct. But when it is i the measure, it does not works

Re: Measure : Calculate does not select right MAX ( date)

Anonymous — Fri, 09 Aug 2024 05:57:11 GMT

Hi HaiVN , aduguid, thank you for your prompt reply!
This works on my sample data according to my tests, please upload your pbix file for further testing if possible.

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Measure : Calculate does not select right MAX ( date)

Anonymous — Mon, 19 Aug 2024 05:29:54 GMT

Hi HaiVN ，

I am looking forward to your feedback if there is any update.

Please remember to update this thread if you have any progress.

Thank you for your understanding.

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.