Filter Table

tarocha , for that you need to create star schema with name, region, and product table. Name is a must in this case.

Please find the file attached after signature

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

tarocha - I created a table like this:

Names = DISTINCT('Table'[NAME])

I related this table to the other table and I replaced NAME column in this table for the NAME column in the original table for Rows. Once I did this, I could click on the dropdown arrow for NAME in Rows and select "Show items with no data".

See attached PBIX file below sig.