Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

data model help

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?

 

 

 

Need Help

2 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    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?

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    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.