Forum Discussion
Helper VApplying constant variable from unrelated table
Resident Rockstarhey,
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.
Helper VHi,
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)