cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mlmagl14
Helper I
Helper I

How to get the average sold of top 3

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. 

 

Data set 1.jpg

 

 

3 REPLIES 3
v-xiaotang
Community Support
Community Support

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
Helper I
Helper I

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

amitchandak
Super User
Super User

@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)
)

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors