Comparing One Category vs All Others in Power BI with DAX

The above video walks you through how to set up a stacked bar chart to show 1 (or more) categories against the rest of the categories in Power BI with DAX. This is a bit difficult to explain without an example, so here’s a gif showing the finished product:

Here’s the final DAX code necessary to set this up:

Sales vs Others = 
VAR CurrentCategory = MAX('Categories + Other'[Category Name])
VAR CurrentCategoryStacked = MAX('Categories + Other (Stacked)'[Category Name])
VAR SelectedCategories = ALLSELECTED(Categories[Category Name])
VAR PossibleCategories = ALL(Categories[Category Name])
RETURN
SWITCH(
   TRUE(),
   CurrentCategory IN SelectedCategories && CurrentCategoryStacked = CurrentCategory, 
   CALCULATE(
      [Total Sales],
      Categories[Category Name] = CurrentCategory
   ),
   CurrentCategory = "Others", 
   CALCULATE(
      [Total Sales], 
      FILTER(
         ALL(Categories[Category Name]),
         Categories[Category Name] IN PossibleCategories
         && NOT(Categories[Category Name] IN SelectedCategories)
         && Categories[Category Name] = CurrentCategoryStacked
      )
   )
)

I hope you enjoyed learning this advanced trick! If you would like to access the data behind this report, make sure to check out my Training courses here. All memberships grant you access to a live SQL Server database to practice Power BI!