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.
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.
What is the measure that goes under the [measure section]?
@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)
)