ALL function for removing filters in Power BI - Dashboard Guide

Dashboard Mode - ALL function for removing filters

Business Question

How can we see total sales ignoring any filters applied on product categories?

Sample Data

OrderID	ProductCategory	SalesAmount
1	Electronics	100
2	Clothing	200
3	Electronics	150
4	Furniture	300
5	Clothing	250

Dashboard Components

• KPI Card: Filtered Sales
  Shows total sales respecting current filters.
  DAX Measure: Filtered Sales = SUM(Sales[SalesAmount])
  Example: If filtered to Electronics, result is 250 (100+150).
• KPI Card: Total Sales (Ignoring Filters)
  Shows total sales ignoring filters on ProductCategory.
  DAX Measure: Total Sales = CALCULATE(SUM(Sales[SalesAmount]), ALL(Sales[ProductCategory]))
  Result always 1000 (100+200+150+300+250).
• Bar Chart: Sales by Product Category
  Displays sales per category respecting filters.
  Values: Filtered Sales measure
  Axis: ProductCategory
• Table: Sales Details
  Shows individual orders with category and sales amount.
  Updates with filters.

Dashboard Layout

+----------------------+-----------------------+
| Filtered Sales (KPI) | Total Sales (KPI)     |
+----------------------+-----------------------+
|                      Bar Chart (Sales by Category)          |
+------------------------------------------------------------+
|                      Table (Sales Details)                  |
+------------------------------------------------------------+

Interactivity

A slicer on ProductCategory lets users filter the data.

The Filtered Sales KPI, bar chart, and table update to show only selected categories.

The Total Sales KPI uses ALL to ignore the slicer filter on ProductCategory, always showing total sales of 1000.

Self Check

If you add a filter selecting only Clothing category, which components update and how?

• Filtered Sales KPI: Updates to 450 (200+250).
• Bar Chart: Shows only Clothing category bar with 450 sales.
• Table: Shows only orders with Clothing category.
• Total Sales KPI: Does NOT update, remains 1000 because it ignores filters on ProductCategory.

Key Result

Dashboard showing total sales with and without filters on product categories using ALL function.