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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try a new measure like

Avg Occurence = averagex(summarize('Table'[Product ID],"_1", COUNT('Table'[Product ID])),[_1])