Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]))
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!
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.
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 |
User | Count |
---|---|
57 | |
21 | |
19 | |
16 | |
16 |
User | Count |
---|---|
86 | |
77 | |
52 | |
37 | |
22 |