Fixing Dynamic Measure Slicer

Anonymous — Thu, 25 Aug 2022 13:57:39 GMT

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?

Re: Fixing Dynamic Measure Slicer

Anonymous — Mon, 29 Aug 2022 02:54:19 GMT

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

topic Re: Fixing Dynamic Measure Slicer in Developer

Fixing Dynamic Measure Slicer

Re: Fixing Dynamic Measure Slicer