cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KarmaPolice Visitor
Visitor

ISFILTERED doesn't work on merged queries table

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

1 REPLY 1
Community Support Team
Community Support Team

Re: ISFILTERED doesn't work on merged queries table

Hi @KarmaPolice

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")

3.png

 

1.png

 

2.png

 

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 88 members 1,551 guests
Please welcome our newest community members: