Compare one to many in aggregate dynamically using Slicer

[Anonymous]

Hi there folks,

I have 4 companies I would like to do comparison (A,B,C,D).  I want to have a dropdown slicer that when I select A, it would do comparison A vs (B+C+D in aggregate).  And when I select B, it would compare B vs (A+C+D in aggregate)....  I can do it by grouping them, but then I have to do for each group separately and cannot dynamically change the comparison.  I think there is a way to do it by adding a new table and have it link back to my data table, but can't seem to get it to work.   

example Above:  Blue bar is Company A, Yellow is company B+C+D

What is need is code to make slicer that when I select Company B,  Blue bar would be Company B, Yellow bar would be A+C+D. 

I appreciate any help.   

[v-chuncz-msft · Accepted solution]

@Anonymous,

Just drag the following two measures.

Measure =
SUM ( Table1[Value] )

Measure 2 =
CALCULATE (
    SUM ( Table1[Value] ),
    NOT ( Table1[Company] IN VALUES ( Table1[Company] ) )
)