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 Ahmedx ,
i tried the similar way by creating a table for category and mapping with my category of actual table and create measure , but its not working for me.
Created a table with this:
category = UNION(DISTINCT(Master[Comments Category]),{"Bench %"})
Used below measure :
IF(SELECTEDVALUE('category'[Comments Category]) = "Bench %",[Bench %],DISTINCTCOUNT(emp no ))
i see values for other categories but bench % is not showing althiugh the values used to calculate for it is used from master table.
there is a one to many relation created between category(comments category) to master(Comments category).
Thanks,
Binay
Share sample pbix file to help you.
show measure [Bench %]