Invoices that contains only one kind of category (product)

[LadislavCarda]

Hi,

i have a table with products, invoices, and row (where is located on warehouse)

It looks like this

Invoice ID	Product ID	Row in Warehouse
20200223	A1	00
20200223	A2	00
20200224	A1	00
20200225	A1	00
20200225	A3	01
20200225	A4	00

From this table, i want to see only invoices that contains ONLY products in Row 00.

In output should be Invoice ID 20200223 and 20200224.

Invoice ID 20200225 should not be in final results.

I tried contains, filters, but no luck.

Thank You!

[LadislavCarda]

Thank You!

[amitchandak · Accepted solution]

@LadislavCarda ,

Try a measure like

measure =
countx(filter(summarize(Table, Table[Invoice ID], "_1",count(table[Row in Warehouse]), "_2", calculate(count(table[Row in Warehouse]), filter(Table, Table[Row in Warehouse] ="00")) ),[_1]=[_2]),[Invoice ID])