Forum Discussion

HaiVN's avatar
HaiVN
Icon for Helper III rankHelper III
2 years ago

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!

DAX
Max (date) in Calculate

4 Replies

  • aduguid's avatar
    aduguid
    Icon for Memorable Member rankMemorable Member
    2 years ago

    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")
    • HaiVN's avatar
      HaiVN
      Icon for Helper III rankHelper III
      2 years ago

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.