Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all,
I am trying to solve the following issue with my data model using DAX.
The table on the right is connected to the table on the left as follows:
left table (contains items) <- right table ( contains the vendor name and manufacturer name in the same column)
- vendor number <- vendor/manufacturer number
- manufacturer number <- vendor/manufacturer number
Is it possible to activate the other relationship using DAX? i.e. Userrelationship without Calculate? I need to list both the manufacturer name and vendor name in the same Power BI visual.
Any help is appreciated! Thanks.
Solved! Go to Solution.
You have other options - TREATAS and LOOKUPVALUE
You have other options - TREATAS and LOOKUPVALUE
Yep. The SQLBI guys also outline FILTER and INTERSECT options in this TREATAS article:
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/
Thank you!