How to get the average sold of top 3

[mlmagl14]

Hi, 

Can somehow tell me how to get the average quantity sold per month by the top 3 selling vendors filtered by the type of product? On my data set I have two types of products, which are pre-rolls and carts. I'd like to create a measure that will show me the average monthly sales of the top 3 vendors by quanity sold of carts. I also need another measure of the top 3 vendors by quanity sold of pre-rolls. Thanks in advance. 

[v-xiaotang]

Hi @mlmagl14 

Thanks for  reaching out to us.

Could you share the sample data in text format? Thanks.

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.

[mlmagl14]

What is the measure that goes under the [measure section]?

[amitchandak]

@mlmagl14 , Try a meausre like

CALCULATE (
averagex(VALUES ( Table[Product Type]), [measure]),
TOPN ( 3, ALL(Table[Product Type]) , [measure], DSC)
)

or

CALCULATE (
averagex(VALUES ( Table[Product Type]), [measure]),
TOPN ( 3, ALLselected(Table[Product Type]) , [measure], DSC)
)