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

Anonymous — Thu, 27 Oct 2022 14:28:31 GMT

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?

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

lbendlin — Wed, 09 Nov 2022 01:49:36 GMT

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

topic Using SWITCH (TRUE(),) but Grand Total calculation is missing in Custom Visuals Development Discussion

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

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