Forum Discussion
Helper IMap not affected by slicer
1. Create a new Calculated Table:
Category = DISTINCT('Grouping'[Category])2. Create a new Calculated Column in your grouping table:
Category Count = 1
3. Add a relationship between the new Category table and the Grouping table.
4. Add the Category Count to the map (size?)
5. Change the Slicer to the new Category table.
Here is the pbix.
Cheers,
Nathan
Helper IOk - I see what you there - that helps a lot thank you so much. I still find it difficult to understand what is the reason behind having to add the Category Count to map - it seems counter intuitive and in no way helpful. I will mark the solution as an answer, thanks.
rvcedd - The reason for the Category Count is to have a data point in the fact table. That is then used to filter to only the values that have data points. In other words, if there is no data in the fact table, the data point is excluded.