Forum Discussion
Map and a Table / or Matrix
I have a map with many locations and a table with additional info for those locations next to it.
I want the table to only be visible when the user clicks on a single location.
Any ideas?
7 Replies
I was thinking HASONEFILTER() but I couldn't get that to work correctly. My understading must be incomplete. Basically, the idea was to create a column:
IsFiltered = IF(HASONEFILTER([Location]),"True","False")
Then set a visual filter on the table to filter out only True values. The theory being that clicking on a country would set HASONEFILTER to True and then the table would display that country's information, otherwise the table would be blank.
However, I can't even get ISFIILTERED or HASONEFILTERED to work correctly as per the walk-through documentation in ISFILTERED.
I ran into similar confusion trying to use ISCROSSFILTERED. I think the way it works is that you are checking to see if what you have selected filters something else. It's a bit counterintuitive, but basically you're checking on how your selection affects other things, rather than checking directly if you have that thing selected. So you wouldn't check HASONEFILTER([Location]), you'd check HASONEFILTER([SomeOtherColumnThatWouldBeFilteredBySelectingOneLocation]). Maybe a location index column. Or, from what I ended up doing in my own measures you might get good results by checking filters on a higher level of location heirarchy. So if you are selecting states or provinces, try HASONEFILTER([Country]).
Thanks for the suggestions! I created a measure with => ISFILTERED => and it works correctly!
FALSE when no locations are selected and TRUE when you click on one!
However as you can see in the picture - there's nothing to select in the Visual level filters and I can't drag it to the Page level filters
