Forum Discussion
Avoid repeating values for multiple fields placed in matrix visual in Values section.
I do not fully understand what you need, but look at my file, it can help you
Hi JoeBarry
Here the values coming in Cat 1, cat 2 ... cat 5 are just a count of emp no , so in values section i have only count of emp no , now to have over all then i need to add another column or measure created for overall category and add in values section , now since it has Count of emp no and overall category in values , the table will show values for all categories twice. which i do not need. Is there any way we can achieve this.
here i need to create a measure or column for overall category and place it in values section below which will make matrix have repeatitive values of Count of emp no and overall category for all the categories.
Hi binayjethwa
I think Ahmedx had the solution for you. above.
First of all, always create measures for values. They can be reused later in other visuals and can be absis for further measures.
1. Create a base Employee Count Measure. this should be enough if using a Matrix. Keep your matrix as is a replace the count with this measure. The Matrix will also show you a total for all categories
Total Employees = DISTINCTCOUNT(Table[Emp no])2. If you need to show certain categories only
Overall categories = CALCULATE([Total Employees], KEEPFILTERS(Table[Categories] in {"category 1", "category 3", "category 5"})
Thanks
Joe
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"}))