Show record from field1 that has the same value in field2 as currently selected

[paweln]

I have simple table. 2 fields. Field1 with unique values. Field2 with string that always repeats two times (for two different Field1 values).  See example:

I would like to select value from Field1 and see (for example in other table) the second value of Field1 with the same value in Field2. I chose 123A, I get 123B and so on. How to do it?

[MayilVahanan]

Hi @paweln 

Try like below

Only({<Field2=P(Field2), Field1=>}Field2)

Sample:

[paweln]

I haven't test this yet but is it possible to get only first column from below table ? To have it in form of a dimension.