Forum Discussion

GQ00's avatar
GQ00
Icon for Helper III rankHelper III
6 months ago
Solved

Top 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...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    6 months ago

    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.

GQ00's avatar
GQ00
Icon for Helper III rankHelper III
6 months ago

edited

v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
6 months ago

Hi GQ00 

Thank you for sharing the update. I'm glad to hear that the issue is now resolved.

If any of the provided solution helped address your scenario, could you please mark or acknowledge the helpful response? This will make it easier for other community members who encounter a similar issue to quickly identify the working solution.

Your confirmation would be greatly appreciated and helpful for the community !!