Forum Discussion
SWITCH + SELECTEDVALUE function doesn't work
Hi jkoclejda
Using a DIVIDE function will return a blank value if the denominator is zero or empty, which is a better approach than using the / operator sign.
Please try the following:
statement =
SWITCH(
SELECTEDVALUE(table_name[category]),
"percentage margin", DIVIDE([margin], [income]),
SUM(table_name[value])
)
[margin] = CALCULATE(SUM(table_name[value]), table_name[category] = "margin")
[income] = CALCULATE(SUM(table_name[value]), table_name[category] = "income")
================= OR ===================
statement =
SWITCH(
SELECTEDVALUE(table_name[category]),
"percentage margin", IF(ISBLANK([margin]) || ISBLANK([income]), BLANK(), DIVIDE([margin], [income])),
SUM(table_name[value])
)
[margin] = CALCULATE(SUM(table_name[value]), table_name[category] = "margin")
[income] = CALCULATE(SUM(table_name[value]), table_name[category] = "income")
See relevant solution on stackoverflow
Please let me know if this help.
Thanks
Babatunde Dallas