Calculating a mean/average based on a measure

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

Anonymous - This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.

Hi Anonymous 

I believe what you are looking for is if 

Then you need the output as 

Occurrence = count('Table'[Product ID])/CALCULATE(COUNTROWS('Table'),ALLSELECTED('Table'))

 IF you need it in percentage convert the measure to %

Anonymous , Try a new measure like

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

Hi Anonymous ,

According to my understanding, you want to calculate frequency of each ProductID based on a measure—“Occurrence”, right?

You could use the following formula:

Occurrence =
CALCULATE (
    COUNT ( 'Table'[ProductID] ),
    ALLEXCEPT ( 'Table', 'Table'[ProductID] )
)

AVG =
[Occurrence] / CALCULATE ( COUNTROWS ( 'Table' ), ALL ( 'Table' ) )

My visualization looks like this:

Is the result what you want? If you have any questions, please upload some data samples and expected output.

Please do mask sensitive data before uploading.

Best Regards,

Eyelyn Qin

Hi Anonymous ,

Did I answer your question? Please mark my reply as solution, thank you~

Best Regards,

Eyelyn Qin