Forum Discussion

Chris123's avatar
Chris123
New Member
9 years ago

Matrix, Count

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

Need Help

2 Replies

  • kcantor's avatar
    kcantor
    Community Champion
    9 years ago

    Chris123

    i would just do a distinct count on the order number and populate that number as the value to the product key rows in a table.

    I believe I answered this on another post, though.

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

    Chris123

     

    In this scenario, you just need to DISTINCTCOUNT() the order numbers group on each category. You can use ALLEXCEPT() in your calculation.

     

    Order Number Count =
CALCULATE (
    DISTINCTCOUNT ( Table[OrderNumber] ),
    ALLEXCEPT ( Table, Table[Category] )
)

    Regards,