Forum Discussion
Solved
Using SWITCH with multiple conditions, SELECTEDVALUE need an option for all
I'm using SELECTEDVALUE to define 2 variables that I'm using in a switch statement like so: NEW_MEASURE = var _inditype = SELECTEDVALUE(MeasureTable[IndicatorType]) var _nation = SELECTEDVALUE...
Hi wynhodgkiss
SELECTEDVALUE will return blank by default if more than one values are selected so assuming that there are only two countries, you can use something like isblank(_nation) = uk + ire
This will return the total value for card and the total value in a table at the total row only.
Hi wynhodgkiss
SELECTEDVALUE will return blank by default if more than one values are selected so assuming that there are only two countries, you can use something like isblank(_nation) = uk + ire
This will return the total value for card and the total value in a table at the total row only.