Market share across selected segments

[Anonymous]

Hi PWBI experts!

I'm wondering how to calculate the share of Company B across selected Segments 2 and 3.

Please notice that Company B has no Sales in Segment 3, but I still want to consider Segment 3 when computing the Share for Company B.

My issue is that when I'm filtering Segment 2 and 3 with a Slicer and I'm filtering Company B with a Slicer, the denominator of my Share gets filtered to only contain Segment 2, and Segment 3 is "indirectly filtered out".

Here the screenshot:

The measures I'm using are the following:

Value SOM = SUM('table'[Sales])/[CY SLS TOT]

CY SLS TOT = CALCULATE(SUM('table'[Sales]),ALL(table[Company]))

Thanks a lot for your help!

Anna

[Anonymous]

Hi @wdx223_Daniel 

It is working! 😊

I thought that with a DAX measure we would solve it, buuut maybe another day jiij

Thanks a lot!

Anna

[wdx223_Daniel · Accepted solution]

@Anonymous if the slicers came from dimension table, then it might be simpler to reslove.

or like this

[Anonymous]

Hi @Nathaniel_C 

Thanks a lot for taking a look at it!

It might definitely solve it, but we are managing several companies and segments, so this sort of data transformation/logic you are suggesting it's something we want to avoid.

I'm sure it should exist a set of DAX measures to compute it, but I'm struggling to find it.

I've been trying to use ALL(), ALLEXCEPT(), ALLSELECTED(), REMOVEFILTERS(), but nothing seems to give me the right output.

Thanks again for your suggestion, appreciate that!

Anna

[Nathaniel_C]

Hi @Anonymous ,
Let's call on Super User @jdbuchanan71  to see if he is available....

Nathaniel

[Nathaniel_C]

Hi @Anonymous ,
Try adding a row to your table that shows segment 3 for B as 0. That will keep the value for segment 3.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel