Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculating a mean/average based on a measure

Hello guys, I have the following measure which counts the number of occurrences of product IDs within a column.   Occurrence = COUNT('Table'[Product ID])   Since I would like to find out how oft...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Please try this expression in a measure

 

Avg Occurence = AVERAGEX(VALUES('Table'[Product ID]), [Occurence])

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat