Forum Discussion
Recalculating Market Share based on selection
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.
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.
Community SupportHi 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.