Fixing Dynamic Measure Slicer

[Anonymous]

I have built a measure slicer that is working almost as expected.

I started by creating a disconnected table with all of my measures:

I then created measures which reference the table to pick which one is displayed on a chart:

A Ancillary/OTC % of Rev = if(selectedvalue(slicertable[slicer value]) = 2 || isblank(selectedvalue(slicertable[slicer value])) ,[Ancillary/OTC % of Rev])

When a single measure is selected, the visual shows that single measure as expected:

However, when selecting 2 or more measures, every measure is shown on the chart. It should only be showing those two measures: 

What am I missing here? Is it the DAX logic? Or the method I have used entirely? 

[Anonymous]

Hi @Anonymous,

AFAIK, selectedvalue does not suitable to handle multiple selections, if you do not set 'alternate result' option it will return blank when you select multiple items.

For this sceaniro, I'd like to suggest adding a variable table with summarize function to do customized to handle each calculation and aggregate them.

SELECTEDVALUE function - DAX | Microsoft Docs

Regards,

Xiaoxin Sheng