KeyId selection of unique values ​​with 2 criteria

Hello,
I want to Select unique values ​​from the same table to populate a dropdown, but with 2 criteria. I know it doesn't seem complicated but I've been all day and I can't find how to do it.
The case is like this:
I have a table of Products, the same product can be in several places with different characteristics. As I take the values ​​from the same table, the same product is repeated many times for each location. What I want to obtain is the Key Id of the unique values ​​of each product in each location.

Something like:
Loc1 ProductA
Loc 2 ProductA
Loc1 ProductB
and so, without product repetitions by agency.

Some help? From already thank you very much

Solved Solved
0 1 121
1 ACCEPTED SOLUTION

You can add a new column « locProduct » with app formula: 

IF(
  IN([_This], tableName[locProduct]),
  “”,
  CONCATENATE([location], [product])
)

Then using this expression, you get the keys of unique entries:

FILTER(“tableName”,
  ISNOTBLANK([locProduct])
)

 

View solution in original post

1 REPLY 1

You can add a new column « locProduct » with app formula: 

IF(
  IN([_This], tableName[locProduct]),
  “”,
  CONCATENATE([location], [product])
)

Then using this expression, you get the keys of unique entries:

FILTER(“tableName”,
  ISNOTBLANK([locProduct])
)

 

Top Labels in this Space