ISFILTERED doesn't work on merged queries table

[Anonymous]

I have two tables imported from separate spreadsheets... 

Projects:

- ID

- Code

- Geo

Surveys:

- Code

- NPS

I combined these tables using an inner join on column "code" with "merge queries" to be:

Surveys_Merge:

- Code

- NPS

- Projects.ID

- Projects.Geo

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... 

[v-juanli-msft]

Hi @Anonymous

Do you create a new measure?

Calculated columns can't change with the slicer.

Calculated columns are only calculated once - when you load/refresh your data model. After that, they contain fixed, static values that can not respond to slicers.

To achieve your goal, you will need to redesign your chart using measures, not calculated columns. 

measure = IF(ISFILTERED(surveys[project.geo]), "True", "False")

Please download my pbix to test on your site. By the way, i'm using the Version: 2.64.5285.741 64-bit (November 2018), please update to the lastest one if there is any error on your site.

Best Regards

Maggie