Forum Discussion
Count occurrence
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)
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
Thank you this worked well!
Do you also happen to know how I can calculate the average of a measure? I would like to calculate the average occurrence in my next step but this doesnt seem to work with average dax function.