Re: Power BI Dax combine sub total of visible tables

Thank you for the idea! I made some customizations to my Power BI setup. I created three tables, each dedicated to a specific slicer, and connected them to the data to enable filtering. This approach allowed me to remove the bookmark or toggle functionality from the code.

For the "TotalYearly" calculation, I used the following code as a reference, which might be helpful to others:

_TotalValue =
VAR _SumProd_Month =
CALCULATE(
SUM('Calendar Year Rebates'[Rebate]),
'Calendar Year Rebates'[Type] = "Month",
'Calendar Year Rebates'[StageFlag] = "PROD"
)

VAR _SumStage_Month =
CALCULATE(
SUM('Calendar Year Rebates'[Rebate]),
'Calendar Year Rebates'[Type] = "Month",
'Calendar Year Rebates'[StageFlag] = "Stage"
)

VAR _SM_Month = SELECTEDVALUE(Dim_Month[ToggleMonth])

VAR _MonthValue = IF(
HASONEVALUE(Dim_Month[ToggleMonth]),
IF(_SM_Month = "ON", _SumStage_Month, _SumProd_Month),
0
)

VAR _SumProd_Quarter =
CALCULATE(
SUM('Calendar Year Rebates'[Rebate]),
'Calendar Year Rebates'[Type] = "Quarter",
'Calendar Year Rebates'[StageFlag] = "PROD"
)

VAR _SumStage_Quarter =
CALCULATE(
SUM('Calendar Year Rebates'[Rebate]),
'Calendar Year Rebates'[Type] = "Quarter",
'Calendar Year Rebates'[StageFlag] = "Stage"
)

VAR _SM_Quarter = SELECTEDVALUE(Dim_Qtr[ToggleQtr])

VAR _QuarterValue = IF(
HASONEVALUE(Dim_Qtr[ToggleQtr]),
IF(_SM_Quarter = "ON", _SumStage_Quarter, _SumProd_Quarter),
0
)

VAR _SumProd_Year =
CALCULATE(
SUM('Calendar Year Rebates'[Rebate]),
'Calendar Year Rebates'[Type] = "Year",
'Calendar Year Rebates'[StageFlag] = "PROD"
)

VAR _SumStage_Year =
CALCULATE(
SUM('Calendar Year Rebates'[Rebate]),
'Calendar Year Rebates'[Type] = "Year",
'Calendar Year Rebates'[StageFlag] = "Stage"
)

VAR _SM_Year = SELECTEDVALUE(Dim_Year[ToggleYear])

VAR _YearValue = IF(
HASONEVALUE(Dim_Year[ToggleYear]),
IF(_SM_Year = "ON", _SumStage_Year, _SumProd_Year),
0
)

VAR _TotalValue = _MonthValue + _QuarterValue + _YearValue

VAR __ValueToShow = IF(ISBLANK(_TotalValue), "-", _TotalValue)

RETURN
IF([Complex Selector]=1,__ValueToShow,BLANK())