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 cate...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft 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,