Forum Discussion

dapperscavenger's avatar
dapperscavenger
Icon for Helper V rankHelper V
2 years ago
Solved

Multiple Selections in a Slicer using a measure

I have created a slicer from a measure using this formula:   This is the dimChange table it refers to:   And the Change Measure it refers to.  The output of this measure is dynamic ba...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi dapperscavenger ,

Please try use ALLSELECTED() and IN:

change_filter = 
VAR _cf = ALLSELECTED('dimChange'[Change Field])
VAR _filter = IF([Change] IN _cf,1)
RETURN
_filter



Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

  • dapperscavenger's avatar
    dapperscavenger
    Icon for Helper V rankHelper V
    2 years ago

    Oh my gosh thank you! This worked!

     

    I was so close to getting it myself because I had been playing about with ALLSELECTED but just couldn't seem to get the formula right