Need your help creating a measure which will be based on a slicer with multiple selection
We have one disconnected "Labels" table where we have list of values as shown below and which will be used as a slicer.
I have another table "Function" which contains these labels as comma separated as shown below
Need to create a measure which will be able to mark 1,0 if the labels selected from slicer "Label" is present in comma separated values. User can select multiple labels as well.
For example, If I select "businessflow" and "custom" from the list then result should be
If I select "businessflow" from the list then result should be
This measure will be used as a filter for other visuals
Go to Solution.
you may try
VAR CurrentLabel =
SELECTEDVALUE ( Function[Labels] )
NOT ISEMPTY (
ALLSELECTED ( Labels ),
CONTAINSSTRING ( CurrentLabel, Labels[Labels] )
View solution in original post
Thank you so much.. It does work 🙂 I am unable to understand the DAX though .. Isn't selectedvalue is for single selection?
Yes. That is the value of the current filter context which we use it to filter ALLSELCTED ( Labels )
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.