select value from another column

[Anonymous]

Hi, 

I have two table:

Table A:

number_id        table b_id

123                          3456

124                           3456

125                           3456

126                           4376

Table B

b_id

3456

4376

i whant to show in table visual the table A (number_id) and the oders filds from Table B, so i need just so pass the talbe A(number_id)

i try this measure: 

CALCULATE(
           FIRSTNONBLANK(TABLE A[NUMBER_ID], 1),
           FILTER(ALL(TABLE A), TABLE A[B_ID] = TABLE B[NUMBER_ID] && TABLE A [U_START] <> BLANK())
) 

but this measure just retrive one value, and i need that retrive me the number_id that are with the same number_id of the second table.

Can anyone help me ?

Best Regards,

JO

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

To create a measure and make the table visual filtered by iy as the picture as below.

Measure = 
VAR a =
    VALUES ( TableA[table b_id] )
RETURN
    IF ( MAX ( TableB[b_id] ) IN a, 1, 0 )