Return all rows from table matching multiple criteria

Hi,

Thank you for clarifying and sorry about not reading your question clearly in the first place.  You had alredy clarified my question in your original post.  You may view my Power Query solution in this Excel workbook.  The same can be done in Power BI dektop as well.

Hope this helps.

hi, Splyn

You could try this way:

Step1:

Create a measure as below:

Measure = VAR _table=VALUES(Brand[Brand])
var _table2=CALCULATETABLE(VALUES('Transaction'[Brand]),ALLEXCEPT('Transaction','Transaction'[Store])) return
CALCULATE(COUNTROWS('Transaction'),FILTER('Transaction', COUNTROWS(EXCEPT(_table,_table2))=0&&'Transaction'[Brand] in _table
))

Step2:

Drag fields from Transaction table and measure into table visual.

Of course, you could just drag measure into visual level filter and set it is not blank

By the way, for Ashish_Mathur code, I have applied it into the demo pbix, you could also try it.

Best Regards,
Lin