Forum Discussion
Solved
Map bubble size by selected value and nothing selected
Area Age group Value New York 0-30 1.1 New York 30-60 6.2 New York 60+ 20.1 New York All ages 6.1 Los Angeles 0-30 1.1 Los Angeles 30-60 4.2 Los Angeles 60+...
Looks like I managed to solve it by myself
IF (SELECTEDVALUE('Table2'[Age Group]) = BLANK(),
SUM('Table1'[All ages value]),SUM('Table1'[Value]))Table2 is table with same agegroups in other visual (which is the initial filtering visual on click)
"All ages value" is calculated column which only contains all ages values (all other age groups are 0)
Looks like I managed to solve it by myself
IF (
SELECTEDVALUE('Table2'[Age Group]) = BLANK(),
SUM('Table1'[All ages value]),
SUM('Table1'[All ages value]),
SUM('Table1'[Value])
)
Table2 is table with same agegroups in other visual (which is the initial filtering visual on click)
"All ages value" is calculated column which only contains all ages values (all other age groups are 0)
"All ages value" is calculated column which only contains all ages values (all other age groups are 0)