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

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

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
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

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.