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 Re: 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