Compare One Group of Company Against Rest of Company

[RyanAppel]

I am looking to compare the gross margin of my company's different branches against the entire company's performance. My company is split into 10 different branches. I am building line graphs over time to show gross margin performance and would like to compare branch XYZ against my company's overall margin numbers for the same time period. My first solution was to use groups and create group 1: branch XYZ and group 2: remaining branches. This does not accomplish what I am looking for as each time I substitute a different branch, the overall company margin performance changes due to branches being substituted in and out. I need the overall company margin performance line to remain constant in each graph I am producing. See below for screenshot of issue. I want the dark blue line to keep the same values it has in the upper graph as it does when comparing our midwest branch to the rest of the company shown in the lower graph.

[v-zhouwen-msft · Accepted solution]

Hi @RyanAppel ,

Regarding your question, I think it is possible to create measures and implement them using the 'ALL' function.

ALL function (DAX) - DAX | Microsoft Learn

The Table data is shown below:

Please follow these steps:
1. Use the following DAX expression to create a measure

This branch = SUM('Table'[Value])

2.Use the following DAX expression to create a measure

Total = CALCULATE(SUM('Table'[Value]),ALL('Table'[Branches]))

3.Final output

[RyanAppel]

This solution worked, thank you!