Forum Discussion
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 ...
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
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
Community Champion
Community ChampionTry 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
That worked! David, you are a rock star!
- dedelman_clng
One further thing to realize is that if there is any other filter anywhere in the report or page (not just on the visual or on a specific slicer) then ISFILTERED is going to return TRUE