How to Compare One Dimension Member to All Others

Hi Anonymous ,

You can meet your needs by slicer visual and stacked bar chart.

At first, you need to edit your model. You will need to create a slicer based on table “Campaign”. So you don't need to create any relationship related to table “Campaign” because it will filter your result.

Here is my test tables and measure “SUM”.

SUM =
SUM ( sheet1[Column1] )

You need to create a measure “ComparedResult” .

ComparedResult =
VAR s =
    SELECTEDVALUE ( Campaign[Column1] )
RETURN
    [SUM]
        - CALCULATE ( SUM ( sheet1[Column1] ), sheet1[Campaign] = s )

Now you can create a stacked bar visual and slicer visual.

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.