Multiple Selections in a Slicer using a measure

[dapperscavenger]

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 based on a parameter that the user inputs:

The slicers works well for single select:

but if a user would want to select multiple values, or select everything except one, it does not filter the table:

Is there a way to make that work?

[Anonymous · Accepted solution]

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]

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 

[amitchandak]

@dapperscavenger , You change measure should join with change field and column from that should be in context 

refer example 

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q