Effecting a KPI when table value is selected.

[Anonymous]

Hi,

I have a dataset whose sample looks like this

Anchor Person	Other Person	Similarity
Jack	Jack	100
Jack	Richard	94
Jack	Mark	89
Richard	Jack	94
Richard	Richard	100
Richard	Mark	92
Mark	Jack	89
Mark	Richard	92
Mark	Mark	100

I have created a below table and a KPI.

My requirement is: Whenever a value is selected from the table then the KPI shows the correct name. But when no value is selected from the table(All selected) then I don't want to show the first value of the Other person column. I want to display "All" written in the KPI. See below left screenshot.

[v-xuding-msft]

Hi @Anonymous ,

The Card is always showing one value. You could change the visual of Card to Multi-row card. 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Xue Ding,

I know we have a multi-card KPI however the client doesn't want to see all the items. We have very less space on our dashboard. 

The client wants "All" to be displayed.

Yesterday I was looking into selectedvalue dax to see if that works.

[v-xuding-msft]

Hi @Anonymous ,

I created a measure. Is this what you want?

Person = IF(SELECTEDVALUE('Table'[Anchor Person]) = BLANK(),"ALL",MAX('Table'[Other Person]))

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Xue,

Thanks for the reply.

However when I try to select othe rperson the KPI still shows "ALL" value