Forum Discussion

Mrecords's avatar
Mrecords
Frequent Visitor
9 years ago
Solved

Shape map: card displaying "ALL" when nothing is selected

Hi all, 

 

I am using Shape Map with various provinces and a Card that shows me the name of the selected province.

Now when no province is selected I can choose to see the name of the First or the Last province, but what should I do to display the text "All" in the Card when no Province is selected? 

 

Thanks!

 

Need Help
  • mbolognesi's avatar
    mbolognesi
    9 years ago

    You can adapt this proposed by Vvelarde:

     

    View solution in original post

     

    First measure would be: 

    FilterProvince = ISFILTERED ( Table[Province] )

    This measure returns FALSE when no province is selected and TRUE when one is selected.

      

    Then you can create a measure to show in a card the name of the selected province or the text "all" when no province is selected, like this:

     

    ShowProvince = IF ( [FilterProvince], SUMMARIZE(Table, Table[Province]), "all")

     

1 Reply

  • mbolognesi's avatar
    mbolognesi
    Frequent Visitor
    9 years ago

    You can adapt this proposed by Vvelarde:

     

    View solution in original post

     

    First measure would be: 

    FilterProvince = ISFILTERED ( Table[Province] )

    This measure returns FALSE when no province is selected and TRUE when one is selected.

      

    Then you can create a measure to show in a card the name of the selected province or the text "all" when no province is selected, like this:

     

    ShowProvince = IF ( [FilterProvince], SUMMARIZE(Table, Table[Province]), "all")