Dashboard Mode - Why intermediate DAX solves business questions
Business Question
How can we use intermediate DAX formulas to answer key sales questions like total sales, average sales per region, and sales trends over time?
0
0
Why intermediate DAX solves business questions in Power BI - Dashboard Impact
Sample Data
| OrderID | Region | SalesPerson | OrderDate | SalesAmount |
|---|---|---|---|---|
| 1001 | East | Alice | 2024-01-15 | 200 |
| 1002 | West | Bob | 2024-01-20 | 450 |
| 1003 | East | Charlie | 2024-02-10 | 300 |
| 1004 | North | Diana | 2024-02-15 | 150 |
| 1005 | West | Eva | 2024-03-05 | 500 |
| 1006 | South | Frank | 2024-03-10 | 350 |
| 1007 | East | Alice | 2024-03-15 | 400 |
Dashboard Components
- Total Sales (KPI Card):
Total Sales = SUM(Sales[SalesAmount])
Shows total sales amount: 2350 - Average Sales per Region (Table):
Average Sales = AVERAGEX(VALUES(Sales[Region]), CALCULATE(SUM(Sales[SalesAmount])))
Calculates average sales by region:
East: (200+300+400)=900, West: (450+500)=950, North: 150, South: 350 - Sales Trend by Month (Line Chart):
Sales by Month = CALCULATE(SUM(Sales[SalesAmount]), FILTER(Sales, MONTH(Sales[OrderDate]) = MONTH(EARLIER(Sales[OrderDate]))))
Shows sales totals for Jan, Feb, Mar 2024:
Jan: 650, Feb: 450, Mar: 1250
Dashboard Layout
+----------------------+-------------------------+ | Total Sales | Average Sales per Region | | (KPI Card) | (Table) | +----------------------+-------------------------+ | Sales Trend by Month (Line Chart) | +---------------------------------------------------------------+
Interactivity
A slicer for Region filters all components. Selecting a region updates total sales, average sales (shows only that region), and sales trend to reflect only that region's data.
Self Check
If you add a filter selecting Region = East, which components update and what results do they show?
- Total Sales: Updates to 900 (sum of East sales)
- Average Sales per Region: Shows only East with 900
- Sales Trend by Month: Shows sales for East by month: Jan=200, Feb=300, Mar=400
Key Result
Dashboard shows total sales, average sales by region, and monthly sales trends using intermediate DAX formulas.