data model help

[Anonymous]

Our company has recently gathered some NPS data and now we want to analyze it.   

One of the slices we want to analyze relates to comparing the NPS results with what customers have ordered.  

The challenge I am facing is how to connect the data model to our Orders table since I would also like to have the NPS data connected to our customer Dim table.     Ideally I'd like to put customer name dimension on a table or matrix with the related customer name from the NPS data.   My current setup does not allow for this.   Any advice?

[v-xiaotang]

Hi @Anonymous 

Only one active relationship can be existing between two tables. If there are multiple query paths between tables, then the data model will be uncertain how one table related to another one.

FYI:

https://blog.enterprisedna.co/how-to-create-virtual-relationships-using-treatas-in-power-bi/#comments

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

Sorry, can you explain what the tables in the depiction are and where the problem lies? You have the Dim customer table related to two tables with the correct relationship. Where is the problem?