Multiple slicer selection with multiple values not displaying

[RPAI2812]

Hello!

I have a radar plot, which I have three measures associated:

• KPI1
• KPI2
• KPI3

In each of those measures I return the value depending on a SELECTED VALUE form a column called "unit". Below is just an example to illustrate something simitar that is written:
Example:
KPI1 = IF(SELECTEDVALUE('Table 1'[Unit]="Unit 1"), [Data 1], BLANK())
KPI2 = IF(SELECTEDVALUE('Table 1'[Unit]="Unit 2"), [Data 2], BLANK())
KPI3 = IF(SELECTEDVALUE('Table 1'[Unit]="Unit 3"), [Data 3], BLANK())

Ps: The [Data X] measures are just calculated measures to return what I want, but it is not that relevant here.

When I select only one of the units from the "Unit" slicer, the plot is perfect and displays what I want.

However, if I select more than one unit, no data appears, the radar keeps blank. I wish I could display multiple radar plots so I can compare the KPIs between units. Is there a way I can rewrite my code so that if I multiple select units on my slicer, the ones I select display normally?

[amitchandak · Accepted solution]

@RPAI2812 , Try like

KPI1 = IF(countx(filter('Table 1','Table 1'[Unit]="Unit 1"),[Unit]) >= 1, [Data 1], BLANK())
KPI2 = IF(countx(filter('Table 1','Table 1'[Unit]="Unit 2"),[Unit]) >= 1, [Data 2], BLANK())
KPI3 = IF(countx(filter('Table 1','Table 1'[Unit]="Unit 3"),[Unit]) >= 1, [Data 3], BLANK())