Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to make a card return predetermined text when no/multiple items in a category selected (example)

https://www.timesunion.com/local/article/More-Capital-Region-students-are-qualifying-for-12497790.php   You can see the example a bit down the page under "Free Lunches..."   When no counties are ...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    7 years ago

    Try this code:

     

    Income Show Text =
IF (
    NOT ( ISFILTERED ( MedianHouseIncome[Geography] ) ),  //No filters
    "Select County",
    IF (
        COUNTROWS ( FILTERS ( MedianHouseIncome[Geography] ) ) > 1, //More than one value
        "Multiple Counties",
        SELECTEDVALUE ( MedianHouseIncome[Geography] ) //else condition, implies 1
    )
)

     

    Hope this helps

    David

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
7 years ago

Try HASONEVALUE

 

IF ( HASONEVALUE ([County]), [County], "Multiple Counties" )

Hope this helps

David

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks a lot, really helped out! I've almost got it, here's the full code I have right now.

     

    Income Show Text = IF(ISFILTERED(MedianHouseIncome[Geography]),"", "Select County") & IF(HASONEFILTER(MedianHouseIncome[Geography]),FILTERS(MedianHouseIncome[Geography]),"") & IF (HASONEVALUE (MedianHouseIncome[Geography]), "" , "Multiple Counties" )
     
    It works when either one county is selected or when multiple are selected (returning county name and "Multiple Counties" respectively. However, when none are selected, it says "Select CountyMultiple Counties". Any ideas for getting around that?
    • dedelman_clng's avatar
      dedelman_clng
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Try this code:

       

      Income Show Text =
IF (
    NOT ( ISFILTERED ( MedianHouseIncome[Geography] ) ),  //No filters
    "Select County",
    IF (
        COUNTROWS ( FILTERS ( MedianHouseIncome[Geography] ) ) > 1, //More than one value
        "Multiple Counties",
        SELECTEDVALUE ( MedianHouseIncome[Geography] ) //else condition, implies 1
    )
)

       

      Hope this helps

      David

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        That worked! David, you are a rock star!

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Okay so after thinking about it more, I see what's happening. The & is a concatenation, so it's putting the Select County and Multiple Counties together because they're both false. When multiple counties are selected it shows up correctly because only one is false.

       

      As a work around I could separate them out into two measures and overlay the cards, but I would really like to avoid that if possible and keep it in one measure.