Slice all row where a certain column value is unique

[jelmer130]

Hi all,

I got an Excel sheet for an inventory system.

• It has a column with a item ID.
• It has a column with a certain warehouse where it is located
• It has a column with a certain condition "new" or "used"

An item can be at multiple warehouses and in multiple conditions (in the same warehouse). 

I would like to make a slice for all the items that are in warehouse A but don't exist in any of the other warehouses.

I hope someone could help me.

Thanks in advance!

Jelmer

[SkrOYC · Accepted solution]

---

@jelmer130 wrote:

I would like to make a slice for all the items that are in warehouse A but don't exist in any of the other warehouses

---

AND(
 [Warehouse]="A",
 NOT(
  IN(,
   [ItemColumn],
   SELECT(
    Table[ItemColumn],
    [Warehouse]<>"A"
   )
  )
 )
)

[jelmer130]

Thank you very much! 

I really appreciate it!