cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rjhartop
Helper II
Helper II

ISFILTERED no longer accepts table arguments, what is the best alternative?

As said the new functionality for ISFILTERED does not accept table arguments:

 

rjhartop_0-1634910199244.png

 

Though it used to, as seen in this screengrab from DAX Guides:

 

rjhartop_1-1634910254987.png

 

I am unsure how best to identify if there is a direct filter on a column, without writing out every possible column in the table - there are many columns in the table and they can change over time.

1 ACCEPTED SOLUTION

ISFILTERED works with a table argument, why are you saying that it doesn't work?

You might see a red line error in Power BI Desktop, just ignore it. IntelliSense has a bug there, hopefully MS will fix it.

 

View solution in original post

2 REPLIES 2
rjhartop
Helper II
Helper II

Ah yep, a combination of some odd bugs in my report, which now appear unconnected to ISFILTERED,  the red underlining bug and a difference between the two documentation sources made me assume there had been an update. Thanks for double checking. I will be much slower with asking for help next time - as was quite trigger happy in contacting you

ISFILTERED works with a table argument, why are you saying that it doesn't work?

You might see a red line error in Power BI Desktop, just ignore it. IntelliSense has a bug there, hopefully MS will fix it.

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.