Using SWITCH (TRUE(),) but Grand Total calculation is missing

[halskwibskc]

Hi all, 

I need the Grand Total value but it is misisng. 

revenuediff = 
var currentweeknum = SELECTEDVALUE(table[weeknum cloumn])
var website = [revenue] - CALCULATE([revenue],FILTER(ALLEXCEPT(table,table[web_site]),table[weeknum cloumn]= currentweeknum -1))
var product = [revenue] - CALCULATE([revenue],FILTER(ALLEXCEPT(table,table[product]),table[weeknum cloumn]= currentweeknum -1))
var size = [revenue] - CALCULATE([revenue],FILTER(ALLEXCEPT(table,table[size]),table[weeknum cloumn] = currentweeknum -1))
var device = [revenue] - CALCULATE([revenue],FILTER(ALLEXCEPT(table,table[device_]),table[weeknum cloumn] = currentweeknum -1))
return
SWITCH(true(),ISINSCOPE(table[web_site]),website,ISINSCOPE(table[product]),product,ISINSCOPE(table[size]),size,ISINSCOPE(table[device_]),device)

[revenue] is a measure btw.

Is there a way to show the grand total correctly? 

[lbendlin]

Grand Total and SELECTEDVALUE are incompatible. Change your formula to avoid the use of SELECTEDVALUE.  Use VALUES  instead, for example.