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>...
DAX
Max (date) in Calculate
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.