Forum Discussion
Solved
Avoid repeating values for multiple fields placed in matrix visual in Values section.
Hi , I have the following requirement , i have below table which i am showing in a matrrix visual . Rows: Emp no and name Columns : Category values : total count Now i need to calculate ...
I do not fully understand what you need, but look at my file, it can help you
Hi JoeBarry ,
The problem is i need to add distinct count of emp no and Count for certain category in matrix , so whether 2 measures or columns if i place both fields in values selection , it will still have repeating values.
I was specifically saying something like this as below image. I dont want repeating values for count of emp no and count of certain category for all categories.
Good morning
this measure could be a basis for counting a specific category.
CALCULATE(COUNT(Table[Categories], KEEPFILTERS([Categories] = "category 1"))
If you need more than one category change the above measure to
KEEPFILTERS In {"category 1", "category 2"}))