Select Record from enum list of another table and show in separate view

G_S
Bronze 3
Bronze 3

Hi 

 

I am having a table A and Table B

Table A has a column called Features 

Feature is a EnumList with base type Text

Table B also  have a column called  Specification 

Specification is a EnumList with base type Text

 

What i am expecting is when i add a record in Table A with some feature like TV ,Camera 

I need to select the row in Table B with the Features value added in Table A

 

Note:

Features and Speciation has the same values like Tv, Camera 

 

I tried a expression with slice but it does not work,

INDEX(SELECT(Table A[Features],[USEREMAIL]=USEREMAIL()),COUNT(select(Table A[Features],[USEREMAIL]=USEREMAIL())))=[_THISROW].[Features],=

 

Please suggest me expression to filter the row  

 

0 8 1,641
8 REPLIES 8
Top Labels in this Space