Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

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? 

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

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