Home › Forums › Power BI › Power BI showing totals on subitems when there is no relationship › Reply To: Power BI showing totals on subitems when there is no relationship
January 15, 2026 at 11:17
#11450
administrator@dailyexcel.net
Keymaster
You can try using a measure such as
BudgetValue =
IF(ISINSCOPE('actual'[product]),BLANK(),SUM'budget'[values]))
This will check if a product is shown on your report and show blanks if that is the case.
Or
BudgetValue =
IF(ISINSCOPE('report'[L1]||'report'[L2]'report'[L3]),SUM'budget'[values]),BLANK())
This will check if your reporting levels are visible and show budget figures, and show blanks otherwise
Br,
