Grand Total when using IsInScope?

[Anonymous]

I have the below measure:

VAR VParent =
FILTER (
SUMMARIZE ( Revenue, 'Customer'[Parent], 'Cost'[Business] ),
[Measure1] > 0
)

VAR MaxParent = MAXX ( VParent, [Measure1] )

VAR SubT = CALCULATE ( [Measure1], VParent )

VAR VLead =
FILTER (
SUMMARIZE ( Revenue, 'Leads'[No], 'Cost'[Business] ),
[Measure1] > 0
)

VAR Max_Leads = MAXX ( VLead, [Measure1] )

VAR SubTotal_Leads = CALCULATE ( [Measure1], VLead )

RETURN
SWITCH (
TRUE (),
ISINSCOPE ( 'Customer'[Customer] ), DIVIDE ( SubT, MaxParent ),
ISINSCOPE ( 'Customer'[Parent] ), DIVIDE ( SubT, MaxParent ),
ISINSCOPE ( 'Leads'[Emp] ), DIVIDE ( SubTotal_Leads, Max_Leads ),
BLANK ()
)

If I select "table" visualization in Power BI, grand total appears BLANK()…

The measure as it is works fine, but I wanted to add a grand total whenever I display it in a table.

I am not sure if it is possible to display a grand total (as an average) of what is displayed. I aim to display a GrandTotal, of whatever is displayed... That is; if 'Customer'[Customer] is in scope, I aim to display the grand total for that.

[lbendlin]

There are a couple of DAX functions for that , like ROLLUPADDISSUBTOTAL function (DAX) - DAX | Microsoft Docs

but you will need to rewrite your measure first to use SUMMARIZECOLUMNS