Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Effecting a KPI when table value is selected.

Hi,

 

I have a dataset whose sample looks like this

Anchor PersonOther PersonSimilarity
JackJack100
JackRichard94
JackMark89
RichardJack94
RichardRichard100
RichardMark92
MarkJack89
MarkRichard92
MarkMark100

 

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.

Need Help

4 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        v-xuding-msft
        Community Support
        7 years ago

        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.