Measure : Calculate does not select right MAX ( date)
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!