Forum Discussion

Jacon25's avatar
Jacon25
Frequent Visitor
6 years ago
Solved

SELECTEDVALUE Context with Slicer

Perhaps I've been going about this the wrong way, but I've been struggling with the following DAX measure.   ShowData = VAR yesterday = CALCULATE(MAX(AllDates[Date]), ALLEXCEPT(AllDates, AllDates[...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , Jacon25 

    Since there is no sample data for test, it is difficult to clarify your problem specifically

    Have you tried to  replace the "ALLEXCEPT" with "ALLSELECTED"?

     

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi , Jacon25 

Since there is no sample data for test, it is difficult to clarify your problem specifically

Have you tried to  replace the "ALLEXCEPT" with "ALLSELECTED"?

 

Best Regards,
Community Support Team _ Eason

Jacon25's avatar
Jacon25
Frequent Visitor
6 years ago

Yes, that is exactly what I was looking for. I wasn't familiar with that DAX function. Thanks!