Select multiple measures in a slicer and show only the selected measures

[Clout]

Hello guys,

I have made one table as as SlicerTable to define the number for each measure:

And then I created these measures for the visual:

EW CSB = IF(SELECTEDVALUE(SlicerTable[Slicer Value]) = 1 || ISBLANK(SELECTEDVALUE(SlicerTable[Slicer Value])), [EW_CSB])

EW BSB = IF(SELECTEDVALUE(SlicerTable[Slicer Value]) = 2 || ISBLANK(SELECTEDVALUE(SlicerTable[Slicer Value])), [EW_BSB])

etc. 

Now when I select EW_CSB in the slicer I get only the visual for EW CSB, and when I select EW_BSB I get only the visual for EW BSB. But when I select more than one Measure in the slicer (EW_CSB and EW_BSB), every four Measures will pop out in the visual: 

Is there a way to only show the selected measures in the visual if I want to show more than one measure?

Thanks in advance.

[v-jayw-msft]

Hi @Clout ,

You will find the value of "ISBLANK(SELECTEDVALUE(SlicerTable[Slicer Value]))" would be true if you select more than one value in the slicer. You could use "NOT(ISFILTERED('SlicerTable'[Selected Measure]))" instead.

Best Regards,

Jay

[Clout · Accepted solution]

Hello @v-jayw-msft and @Jihwan_Kim, thank you very much for your suggestions. But I solved this problem already.

My measure now looks like this and this works with multiple selection too:

EW_BSB = IF(CONTAINS('Slicer Table New', 'Slicer Table New'[Value], "EW_BSB"), [EW_BSB] , BLANK())

[Jihwan_Kim]

Hi, @Clout 

Please correct me if I wrongly understood your question.

Instead of using selectedvalue, please try to use ALLSELECTED together with IN function.

If it is OK with you, please share sample pbix file's link after deleting important data, then I can try to look into it to come up with a more accurate measure.

Thank you.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/