I have two tables imported from separate spreadsheets...
I combined these tables using an inner join on column "code" with "merge queries" to be:
With these combined, I created a slicer on "Surveys_Merge[Projects.Geo]"
And a data card with the value of: IF(ISFILTERED(Surveys_Merge[Projects.Geo]), "True", "False")
In theory this should show "False" if nothing is selected in the slicer, and "True" if something is selected in the slicer... however I'm finding that it just always returns "False" no matter if anything is selected in the slicer or not.
Can anyone else verify this behavior on merged tables? I realize there are easier ways to accomplish the above, but the above is a simplification for testing/illustration of my actual problem which requires merged queries, so I'm trying to get the "ISFILTERED" working against a slicer from a merged queries table...