Retrieve the Max date from slicer

[sammy02hk]

Hi there,

I would like to retrieve the Max date from slicer.
What I want is test fix @06/12/2022, rather than 06/11/2022 for site 1001

test = CALCULATE(MAX(DATA_LIST_CUR_DateMatch[Date]),ALLSELECTED(DATA_LIST_CUR_DateMatch[Date]))

Thank you for your help.

Cheers,
Sammy Chu

[andhiii079845]

Same problem ike @wdx223_Daniel . One way can be to us a separate dimTable and us the date from this table as a slicer.

[wdx223_Daniel]

not really get your point.

but, if these is not data at Jun 12 for site 1001 in your fact table, your measure will never get the value of Jun 12.

[sammy02hk]

@wdx223_Daniel 
I am trying to fix the var value @12/6/22 rather than 11/6/22 bypass the fact data.