Lookup from another column only for one criteria all others refer to one column from same table

[sure19]

I have two KPI tables.  one has KPI which has a list of KPI's, KPI Type which has a list of types such as RTG, QC etc.  and KPI Values which has the value for each of the KPI and type.  but when you select QC, it should not take the value from KPI_Value but it should fetch the data from another table where there is a column called QC moves.

[v-shex-msft]

Hi @sure19,

Can you please share some dummy data and the expected results? It is hard to clarify your requirements and do test from your description without any detail sample data.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[sure19]

hi Sheng,

here is the table attached https://1drv.ms/u/s!ArSIdgxdNuYwlhd6a6RpW8RKynbV?e=DTMoyw

[v-shex-msft · Accepted solution]

HI @sure19,

You can use the following measure formula to extract table records and filter and calcite on other KPI table:

Measure =
CALCULATE (
    SUM ( TP_ENG_KPI[QC MOVES] ),
    FILTER (
        ALLSELECTED ( TP_ENG_KPI ),
        [TPA LOCATION NAME] IN VALUES ( OPS_YARD_MOVES[TERMINAL] )
    )
)

Regards,

Xiaoxin Sheng