Dynamic measure based on a slicer with muti select option

[Deemo]

Hello,

Need your help creating a measure which will be based on a slicer with multiple selection

Eg:

We have one disconnected "Labels" table where we have list of values as shown below and which will be used as a slicer.

Labels

Tag1

dynamicparam

core

custom

businessflow

subflow

I have another table "Function" which contains these labels as comma separated as shown below

Name	Lables
Function1	Tag1,dynamicparam,core
Function2	Tag1,businessflow,core
Function3	custom,dynamicparam
Function4	custom,dynamicparam
Function5	custom,businessflow,subflow

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 

Name	Lables	Measure
Function1	Tag1,dynamicparam,core	0
Function2	Tag1,businessflow,core	1
Function3	custom,dynamicparam	1
Function4	custom,dynamicparam	1
Function5	custom,businessflow,subflow	1

If I select "businessflow" from the list then result should be 

Name	Lables	Measure
Function1	Tag1,dynamicparam,core	0
Function2	Tag1,businessflow,core	1
Function3	custom,dynamicparam	0
Function4	custom,dynamicparam	0
Function5	custom,businessflow,subflow	1

This measure will be used as a filter for other visuals

[tamerj1 · Accepted solution]

Hi @Deemo 

you may try

Measure1 =
VAR CurrentLabel =
    SELECTEDVALUE ( Function[Labels] )
RETURN
    NOT ISEMPTY (
        FILTER (
            ALLSELECTED ( Labels ),
            CONTAINSSTRING ( CurrentLabel, Labels[Labels] )
        )
    )

[Deemo]

Thank you so much.. It does work 🙂 I am unable to understand the DAX though .. Isn't selectedvalue is for single selection?

[tamerj1]

@Deemo 

Yes. That is the value of the current filter context which we use it to filter ALLSELCTED ( Labels )