Forum Discussion
Count occurrence
Hello guys!
I wonder if there is a solution for the following. I want to count the number of occurence of each Product ID.
Input:
| Product ID |
| B |
| B |
| B |
| C |
| C |
| D |
| D |
| D |
| D |
| D |
Expected Output
| Product ID | Occurence |
| B | 3 |
| C | 2 |
| D | 5 |
Is there a way to achieve this through DAX?
Thank you!:)
Just drag your Product ID column into a table visual, and add this measure too.
Occurence = COUNT(Table[Product ID]) //replace table with actual table name
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Anonymous , on any visual plot this measure with product id
countrows(table)
3 Replies
Just drag your Product ID column into a table visual, and add this measure too.
Occurence = COUNT(Table[Product ID]) //replace table with actual table name
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Anonymous , on any visual plot this measure with product id
countrows(table)