Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Grand Total and SELECTEDVALUE are incompatible. Change your formula to avoid the use of SELECTEDVALUE. Use VALUES instead, for example.