power kpi matrix
1 Topic
PowerBI: Count values in a Matrix
Hello All, I am trying to figure out how to count the values inside a matrix in a measure. My raw data looks like this. I have a large number of values and a large number of categories that the Category Type can be. VALUE# Category Type Value1 Category 1 Value1 Category2 Value2 Category3 Value 2 Category 3 Value 3 Category 30 I would like to be able to identify if any duplicates exist per Value. For example, in a matrix it would look like: Category1 Category2 CategoryN Value1 Count of category1 Count of category2 Count of categoryN Value2 Count of category1 Count of category2 Count of categoryN Value3 Count of category1 Count of category2 Count of categoryN So that my final data can look like: Is there any duplicate? Value 1 No Value2 Yes Value3 No I am interested in wrapping this up to a measure rather than show the visualization of the matrix in the report.Solved8.5KViews0likes5Comments