Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
HaiVN
Helper II
Helper II

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!

4 REPLIES 4
v-yajiewan-msft
Community Support
Community Support

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.

v-yajiewan-msft
Community Support
Community Support

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.

vyajiewanmsft_0-1723182842676.png

Best regards,

Joyce

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

 

aduguid
Super User
Super User

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")

@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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors