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...
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)
amitchandak
Super User
Super UserAnonymous , on any visual plot this measure with product id
countrows(table)