how to do dynamic comparison between a selected company and rest of companies

[Anonymous]

Hi PowerBI community, I need to do a dynamic analysis compare the pv share by customer groups between a selected single company and the rest of the market. Now I create 2 measures, it seems to work for most scenarios.

PV all company = CALCULATE(SUM('550 check'[pv]),ALL('550 check'[company]))

PV ROVC = [PV all company]-SUM('550 check'[pv])

I use company as a slicer. When I select different company, Chart B won't change. Chart C represents the pv share of the company I selected, Chart A will show the difference between Chart B and Chart C.

But if I select a company that only has one customer group, these charts won't work as I wished.

How can I achieve Chart A & Chart B still have 2 customer groups' data if when I select a company with only 1 customer group? Thank you!

[YukiK]

Do you have some sample data for this? I'm thinking adding ALL(customer group) might help, but I'd be able to further examine with some data.

[Anonymous]

I made up some numbers, but should work. Let's assume the market only has 3 companies now:

company	customer group	pv
A	affluent	7228
A	core	9104
B	affluent	6984
B	core	8274
C	core	8778