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.

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
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-karpurapud's avatar
      v-karpurapud
      Icon for Community Support rankCommunity Support
      6 months ago

      Hi GQ00 

      We have not received an update from you for some time. To assist you in resolving the issue, we kindly request that you provide the necessary details. Once we have this information, we will be able to address your concern effectively.

      Thank you.

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

        Hi GQ00 

        It's been a while since we last heard from you. We are ready to assist you with resolving the issue, but we need the necessary details from you. Kindly share the information required so we can better understand and address your issue.

        Thank You.