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 s...
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] ) )
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity 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] ) )
)