Forum Discussion
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(ALLEXC...
Grand Total and SELECTEDVALUE are incompatible. Change your formula to avoid the use of SELECTEDVALUE. Use VALUES instead, for example.