Forum Discussion
Multi-level Slicing by Measure?
Did you try using a What-If Parameter? Sounds like a case for that. If you're using a measure and not a column for your games played calculation, this should respect the filter context of league and player, etc.
Thanks for the suggestion. I created a What-If for 0-40 games, incremented by 1. I wrote a measure that states to return the KPI only if the [Game Count] > Slicer Selection of the What-If. This seems to produce expected results from a table, as players who have fewer than the selected number of games don't have any values populated in the column. However, the column total remains unchanged. I would expect the column total to reduce as the number of games goes up. It also doesn't function like a normal slicer, in a way that I'd want those players who have fewer than the selected number of games to simply disappear.
I created this after researching What-Ifs only briefly. If there is a better way to do it, I would be interested in learning. Additionally, it would be nice to harness the selected values of a slicer that is set to "Between" rather than a single selection.