Forum Discussion

Rogerh's avatar
Rogerh
Helper II
6 years ago
Solved

Lookup another table with Multiple Values, if one value is correct report back

Good morning all,   I need some help please! I have two tables, Orders and Product Builder; The order table has a single line for each order. The Product table is the order broken down by each line...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi Rogerh ,

     

    I think you missed my last response. Try using following dax:

    Try something like this:
    Delivery Charge = Var lookup = CALCULATE(FIRSTNONBLANK('Platform - Pro Builder'[supplier_id], 1), FILTER(ALL('Platform - Pro Builder')'Platform - Pro Builder'[order_id] = 'Platform - Orders'[order_id]))
    Var checkVal = 987
    RETURN
    IF( lookup = checkVal, "YES", "NO")
     
    Thanks,
    Pragati
Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Rogerh ,

 

I think you missed my last response. Try using following dax:

Try something like this:
Delivery Charge = Var lookup = CALCULATE(FIRSTNONBLANK('Platform - Pro Builder'[supplier_id], 1), FILTER(ALL('Platform - Pro Builder')'Platform - Pro Builder'[order_id] = 'Platform - Orders'[order_id]))
Var checkVal = 987
RETURN
IF( lookup = checkVal, "YES", "NO")
 
Thanks,
Pragati
Rogerh's avatar
Rogerh
Helper II
6 years ago

Pragati11  That worked 🙂 thank you very much for your help