Forum Discussion

George1973's avatar
George1973
Icon for Helper V rankHelper V
5 years ago

Applying constant variable from unrelated table

Hi All,

I have the following issue:

There are two not directly retalted lookup tables - "Vendors" and "Goods". They are related through the data table "Operations".
Each vendor has its own delivery days field. I'm trying to use/apply these field for the relevant/related (through operations table) goods as well. ..And I fail 😞

 

Here is the sample visualition of the issue:

In another words I would like to create a dax measure calculating "delivery days" for each product related to the supplier.

 

Please help me with it.

 

Thanks in advance

 

 

 

 

 

2 Replies

  • StefanoGrimaldi's avatar
    StefanoGrimaldi
    Icon for Resident Rockstar rankResident Rockstar
    5 years ago

    hey, 

     

    you can create a measure that sum the delivery days and us the userrelantionship funtion to activate a relantionship between those 2 unrelated table for this dax example: 

     

    calculate(sum(table vendor[delivery days]),USERELATIONSHIP(table vendor[suplier],table product[supplier index])

     

    if this was of help give some kudos, if solved you question mark as solution for others to find. 

    • George1973's avatar
      George1973
      Icon for Helper V rankHelper V
      5 years ago

      Hi,

      Thanks for the feedback.  That formula might work if I had supplier index in product table, but I have not, that's why the field is gray assuming how I want to assign the result by the suppliers.

       

      As described - The only relation we have between those two vendors and products table is "Operations" data table with it Operation_ID.

      The slicers and page filters work perfectly when using those two tables and measures from binare related data tables, like in the picture below:

      (The products are filtered based on the selected vendor from the right table).

      But when I try to assign "delivery days" from vendors to products directly, it does not work, even with your suggested formula:

      (Here we have the total sales dissapiared and "correct" delivery days, from ALL product list, without filter)