Structured Financial Report-Subtotal - Power BI

The subtotal problem in financial reports is a classic Power BI challenge — SELECTEDVALUE only works at the detail row level, so when the visual renders the subtotal row, there's no single value selected and the measure returns blank.
The fix is to use ISINSCOPE to detect which level of the hierarchy you're at and calculate accordingly:
daxFinancial Amount =
IF(
ISINSCOPE('ChartOfAccounts'[ExpenseCode]),
-- Detail level: return the individual account amount
SELECTEDVALUE(...your existing logic...),
-- Subtotal/total level: sum all amounts in the current group
CALCULATE(SUM('FactTable'[Amount]))
)
The key insight is that at the subtotal row, ISINSCOPE('ChartOfAccounts'[ExpenseCode]) returns FALSE because you're no longer scoped to an individual expense code — you're at the Report Category level. So you can branch the logic: detail rows get your SELECTEDVALUE logic, and subtotal rows get a regular SUM that aggregates everything in the current filter context.
If your report structure has multiple levels (e.g., Category → Subcategory → Account), you'd nest multiple ISINSCOPE checks:
daxFinancial Amount =
IF(
ISINSCOPE('ChartOfAccounts'[ExpenseCode]),
[Detail Level Measure],
IF(
ISINSCOPE('DimReport'[SubCategory]),
[SubCategory Subtotal],
[Grand Total]
)
)
If some subtotals need to be calculated differently (e.g., Gross Profit = Revenue - Expenses rather than just summing children), you'd handle those specific rows with additional SELECTEDVALUE('DimReport'[ReportID]) checks inside the subtotal branch.

Power BI matrix follows a hierarchy so a combination of conditional measures and a disconnected is normally needed to get the desired layout. The actual solution depends on the data. Below is an example result using such an approach. Notice that Gross Profit, Budget and Variance although expanded do not have anything under them.