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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.