Forum Discussion
Filtering matrix rows by a column value
I created a matrix with client names and colums of different policy types. the measure in the matrix, is the count of distinct plicy numbers. I want to be able to only filter the # of clients who ha...
So it looks like in your example data, each person has 1 policy number, but can have different types of policy under that same policy number? What happens when you use COUNT of policy number instead of DISTINCTCOUNT?
I would use a count of the category column insetad of distinct policy numbers, so that the total comes out correct. You may have to use a measure like this to create a visual level filter or slicer:
NumberOfCategories = COUNT(Policies[Type])
and then filter on that where it's greater or equal to 2.
Could you share how you have your table(s) structured? It would help us give you a better answer