topic Re: Dynamic measure based on a slicer with muti select option in DAX Commands and Tips

Dynamic measure based on a slicer with muti select option

Deemo — Thu, 21 Apr 2022 17:00:42 GMT

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

Re: Dynamic measure based on a slicer with muti select option

tamerj1 — Thu, 21 Apr 2022 19:51:53 GMT

Hi Deemo

you may try

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

Re: Dynamic measure based on a slicer with muti select option

Deemo — Fri, 22 Apr 2022 13:11:07 GMT

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

Re: Dynamic measure based on a slicer with muti select option

tamerj1 — Fri, 22 Apr 2022 13:14:22 GMT

Deemo

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