Count values matrix

[Chris123]

If i have a Matrix with different categories in the first column and ordering numbers that includes the specific category in the second column. How do count how many ordering numbers there are in each category?

[v-huizhn-msft]

Hi @Chris123,

I create sample table. There are categories in the first column and another sun-categories.



Create a measure. 

Measure = CALCULATE(SUM(Table6[number]),ALLEXCEPT(Table6,Table6[category],Table6[sub-category]))

Create a matrix. Select the category as row level, and sub-category as column level, please see the following screenshot.



If this is not what you want, please post your sample data for further analysis?

Best Regards,
Angelia