Forum Discussion
Helper VMultiple 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 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?
Hi dapperscavenger ,
Please try use ALLSELECTED() and IN:change_filter = VAR _cf = ALLSELECTED('dimChange'[Change Field]) VAR _filter = IF([Change] IN _cf,1) RETURN _filterBest Regards,
Gao
Community Support TeamIf 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
3 Replies
Hi dapperscavenger ,
Please try use ALLSELECTED() and IN:change_filter = VAR _cf = ALLSELECTED('dimChange'[Change Field]) VAR _filter = IF([Change] IN _cf,1) RETURN _filterBest Regards,
Gao
Community Support TeamIf 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
dapperscavengerOh 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
Super User
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
