Applying constant variable from unrelated table

[George1973]

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

[StefanoGrimaldi]

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]

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)