Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 36 | |
| 34 | |
| 31 | |
| 27 |
| User | Count |
|---|---|
| 136 | |
| 103 | |
| 66 | |
| 65 | |
| 56 |