measure for categorizing average of individual averages

[jeevan_j97]

Hi All

I need help creating a measure for an average of a measure which calculates proportions at a siteid level.

Currently I have the above table which calculates proportions for each site, product and crossshopproduct.

I now want a measure for a different table which can average all of the different sites' %'s grouped by product name and crossshopproduct.

This is my currrent measure to find the proportions, very simple as the table does the filtering. 

Proportion of baskets that contain another BU =

CALCULATE(SUM('Store Cross Shops BU'[crossshoppedtransactions]) / MAX('Store Cross Shops BU'[totalbasketswithproduct]))

I need a result that will put the averages into this matrix.

[v-xiaotang]

Hi @jeevan_j97 

Thanks for reaching out to us.

Could you please share some sample data and its expected outcome? 

For this example image, I can't see what your raw data looks like and how I need to calculate this data (calculation formula) and its correct result, so that I can check whether my measure is correct according to your expected output.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.