cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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.

 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors