Forum Discussion
GQ00
Helper III
Helper IIITop 3 Average Sales mix
Hi, I'm trying to highlight the revenue opportunity of aligning sales mix of certain products to top performing stores. The fact salesitem table is related to tables such as Store, Product, D...
Hi GQ00 - your logic is correct conceptually, but the measures are being evaluated at Area Manager / Product Manager levels, not strictly at Store level.
Top3 Mix =
AVERAGEX(
TOPN(
3,
ALLSELECTED(Store[Store]),
[Mix %],
DESC
),
CALCULATE([Mix %])
)use the above, ensures ranking happens only by Store, try the above logic,
Hope this give the right result and check , still if any pls shae some sample data to test it.
danextian
Super User
Super UserI'm confused. First your sample result does not match your sample pbix. Your pbix is looking at top2 but your result is top3 and total $ value without any filter is 815 bur your screenshots shows 162K. Anyway, try the attach pbix. Otherwise, please ensure your expected result uses the same data in your pbix.
