Forum Discussion

Chris123's avatar
Chris123
New Member
9 years ago

Count values matrix

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?


1 Reply

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    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