How to get a filtered data from another table

[BrianLee]

The table A above has a column called range, and the table B has a weight value column.

This weight value is 420, so it belongs to less than 500 and greater than 0. So I want to get the corresponding rate value in the end which is 14.84  in this case..   how can I sort this out..? 

[v-cgao-msft · Accepted solution]

Hi @BrianLee ,

Please create a new calculated column:

state_id = 
CALCULATE (
    MAX ( 'TableA'[rate] ),
    FILTER ( ALL ( 'TableA' ), 'TableA'[Range] < 'TableB'[Weight] )
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum