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