Forum Discussion

Rogerh's avatar
Rogerh
Icon for Helper II rankHelper 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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Rogerh , Create a new column

if(isblank(countx(filter(Table,[Order ID] =earlier([Order ID ]) && [Supplier] =987),[Supplier])),"No","Yes")

  • Rogerh's avatar
    Rogerh
    Icon for Helper II rankHelper II
    6 years ago

    Hi amitchandak 

     

    Thank you for your reply, i have tried your code but I can not get it to work.

     

    Where you reference the table below (after filter), is that the order table or the product? Could you also confirm which table each of the order_ids come from? Thanks