Forum Discussion
Unable to create relationships between tables
Super UserI think the issue here is creating a many-to-many relationship between two fact tables as well as the ambiguity created by having multiple possible paths from Locations to Patient Falls (directly or through Patient Days).
I recommend reading this article to get a better idea what I mean:
https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/
Thanks AlexisOlson! I was only able to use many:many because I had duplicate values both look-up tables. I cleaned them up and was able to revise my relationships. Below is what I have now, but I'm still getting repeating values! Any ideas on where to go from here?
Thank you!!
- AlexisOlson
It's not clear to me what you mean by "getting repeating values". Can you elaborate?
AlexisOlson My # of Patient Days displays correctly, but the same # for patient falls repeats down the column when I try to link them together. The falls count displays correctly when I have it in a seperate table.
PaulDBrownCommunity Champion
If you don't have an "Units" column in the Patients Fall table you will get this. If you do have a Units column in both tables, you need to create a dimension table for Units too. In fact, you should create dimension tables for all fields common to both tables and use the dimension fields in visuals, slicers, measures, filters...