March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
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!
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.
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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
62 | |
27 | |
25 | |
22 | |
16 |