Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Hi @BIDev4Life,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
25 | |
3 | |
2 | |
2 | |
2 |