topic Re: Applying constant variable from unrelated table in DAX Commands and Tips

Applying constant variable from unrelated table

George1973 — Fri, 26 Mar 2021 09:46:32 GMT

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

Re: Applying constant variable from unrelated table

StefanoGrimaldi — Fri, 26 Mar 2021 11:25:32 GMT

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.

Re: Applying constant variable from unrelated table

George1973 — Fri, 26 Mar 2021 17:30:30 GMT

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)