Forum Discussion
2 fact table fields linking to 1 reference table
Hey,
Sounds like a easy fix, check out this video on creating relationships -
Hi jim2004 , what types of measures and visuals do you anticipate wanting to build off of these two different fields?
The method you described of having two dimension tables is one approach, but another would be to stick with a single customer master and create a 2nd "in-active" relationship with the fact table. Then, by using the USERELATIONSHIP you can toggle each relationship on and off within a measure as needed. There are pros and cons to both approaches, but which to use would depend on what you're trying to accomplish.
https://www.sqlbi.com/articles/using-userelationship-in-dax/
It's really just for reference. I'd be pulling things like name, address zip, ect. I am not familiar with how to mange the inactivate relationship but I will explore this further. Thank you for the help.