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.
Perfect, thanks so much