Forum Discussion

Andrew_na_lang's avatar
Andrew_na_lang
Icon for Helper V rankHelper V
4 years ago
Solved

Count unique item codes per order id

Hi Fam,   I have a table matrix where the item codes are sorted by the order id.  I need to know how many unique items are received per order id.    In the example above, the total ite...
Tutorial Requests
  • Tahreem24's avatar
    Tahreem24
    4 years ago

    Andrew_na_lang , Try this measure:

    MEASURE = CALCULATE(DISTINCTCOUNT(TableName[Item No]),ALLEXCEPT(TableName,TableName[OrderID]))

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
4 years ago

Andrew_na_lang , Try this measure:

MEASURE = CALCULATE(DISTINCTCOUNT(TableName[Item No]),ALLEXCEPT(TableName,TableName[OrderID]))