Reply To: Power BI showing totals on subitems when there is no relationship

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

#11450

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,