Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Compare one to many in aggregate dynamically using Slicer

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.   

 

 

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    Just drag the following two measures.

    Measure =
SUM ( Table1[Value] )

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

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

    Anonymous,

     

    Just drag the following two measures.

    Measure =
SUM ( Table1[Value] )

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