Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Recalculating Market Share based on selection

Hi everyone,    I have a technical question. I want to know how you would best assess this issue. Context - Market Shares: Market Shares can be calculated in many ways. If we take below table as a...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI amitchandak 

     

    I found just the right solution actually (I believe and checked).

    Market Share (whatever the context is always calculated by doijg = sum of sales of a part / sum of sales of all parts.

    We know that calculate(sum(sales)) will be (if we let him) influenced by the "slicers".

    The question is thus how we make a measure that defines the ALL PARTS segment, as we want that all part to be dynamic based on selection. That's where it hit me:

     

    USE ALLSELECTED on the table you allow the recalculation to be done. And it works ... The total of all parts is recalculated based on filter selection.

     

    What's your opinion on this?

    Thanks a bunch.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , so basically it will be based on the filter choose to measure. typically for Guage, you should be done with isfiltered and hasonebvalue.

 

In the case of visual with group/axis/row, you have to use isinscope too.

 

My example of card - https://www.youtube.com/watch?v=hXg3kRFSGjA

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI amitchandak 

 

I found just the right solution actually (I believe and checked).

Market Share (whatever the context is always calculated by doijg = sum of sales of a part / sum of sales of all parts.

We know that calculate(sum(sales)) will be (if we let him) influenced by the "slicers".

The question is thus how we make a measure that defines the ALL PARTS segment, as we want that all part to be dynamic based on selection. That's where it hit me:

 

USE ALLSELECTED on the table you allow the recalculation to be done. And it works ... The total of all parts is recalculated based on filter selection.

 

What's your opinion on this?

Thanks a bunch.

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    I think so too, thank you for sharing.

     

    Best regards,
    Lionel Chen

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