Forum Discussion
Why does removing a filter with ALL repeat values in a visual matrix?
Yes, the filters for the subcategory are still in the filter context.
This is why you get different values for each subcategory (within a given category that is being ignored).
However, the ALL('Product Category') removes the filter on the Product Category.
As a result, each Product Category line in the the visual isn't going to reflect the number for the Product Category (but rather the number for ALL categories).
Correspondingly, each of the subcategories are NOT being filtered by the category either. So each subcategory is showing the total number for that subcategory across all categories. This is why the numbers repeat for each Category; because the calculation can't see the category.
Hope this is helpful to you.
Regards,
Nathan
Yes, the filters for the subcategory are still in the filter context.
This is why you get different values for each subcategory (within a given category that is being ignored).
However, the ALL('Product Category') removes the filter on the Product Category.
As a result, each Product Category line in the the visual isn't going to reflect the number for the Product Category (but rather the number for ALL categories).
Correspondingly, each of the subcategories are NOT being filtered by the category either. So each subcategory is showing the total number for that subcategory across all categories. This is why the numbers repeat for each Category; because the calculation can't see the category.
Hope this is helpful to you.
Regards,
Nathan