Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
David_CMR
Frequent Visitor

Simple (??) filter on a Countrows

Okay I thought this would be if not simple at least something I could figure out, but it's just not working right.
I want a explicit measure that counts all the rows in the table, after applying a set of filters coming from inside and outside the table I want to count the rows of.

If any of them are true I want the row filtered out.
in order of less to more complex filters:

Filter out a certain string from a column from the main table.

Filter out a list of strings from a different column in the main table (usingNOT IN{}).

Filter out rows from the main table that contain a specifc string from a related table (highlighted green in the screenshot)

Filter rows out that have a relationship to a specific table (using EXCEPT) (highlighted in blue in the screenshot)
 

I've tried what feels like dozens of different ways of doing this starting with calculate with filters to creating virtual tables and sets of filters as Variables, most of the time I can get the measure to run but with a completely or subtly wrong result. I don't know if I actually got close to doing it right and gave up or if there is something significant I don't understand here.

 







Screenshot 2023-02-19 135350.png



1 REPLY 1
vanessafvg
Community Champion
Community Champion

you need provide some sample data with your expected solution.  you have some relationships that could be potentially giving you issues, however you neeed to give more information.

 

1. sample data

2. your expected result from that data

3. the measures you have tried that aren't working.

 

its hard to commeent on the issue without this information.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.