This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA 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.
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.
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.
Proud to be a Super User!
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 29 | |
| 28 | |
| 25 | |
| 19 | |
| 14 |
| User | Count |
|---|---|
| 53 | |
| 47 | |
| 27 | |
| 20 | |
| 19 |