Forum Discussion
Andrew_na_lang
Helper V
Helper VCount 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...
Andrew_na_lang , Try this measure:
MEASURE = CALCULATE(DISTINCTCOUNT(TableName[Item No]),ALLEXCEPT(TableName,TableName[OrderID]))
Hi,
It would be easier to give suggestions and solutions, if we knew your desired output format and had a table format of your sample data 🙂
Check out the sections in the following link:
- Include Your Expected Result
- When posting data, put it in a nice format
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447595#M607169