Forum Discussion

JillHenninger's avatar
JillHenninger
Helper I
5 years ago

Fair Share Calculation

Hi all. I am trying to create a series of calculations using Dax, and I am stuck on a piece. Context: First, I need to calc market share - how much is our account selling of a specific product with...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Community Support
5 years ago

Hi JillHenninger ,

 

Try the following formula:

 

Measure = 
SUMX(
    FILTER(
        ALLSELECTED(ClientList[Client]),
        ClientList[Client] = "Total Departments"
    ),
    [Market Share]
)

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • JillHenninger's avatar
    JillHenninger
    Helper I
    5 years ago

    Thank you! Alas, that formula have me the exact same result (14.8%) as before and as before, only for the top row...

    • v-kkf-msft's avatar
      v-kkf-msft
      Community Support
      5 years ago

      Hi JillHenninger ,

       

      Could you please share the relationship between the tables in the Model view?

       

      In your Fair Share formula I see that you have restrictions on client

                                           ClientList[Client]="Total Departments",

      so the calculation result you want is consistent (14.8%)?

       

       

      Best Regards,
      Winniz

       

      • JillHenninger's avatar
        JillHenninger
        Helper I
        5 years ago

        Sure - here is the model. TA and xAOC are the made data sources; the rest are mapping files.

        My products are Total Departments (ie the total retailer), then Clients (ie manufacturers). The clients don't total up to the Total Departments; and Total Departments is a singular product pulled from our system. So, it will change as retailer and time period changes. But - I don't want it to change depending the product (row) displayed...