Forum Discussion
Unable to create relationships between tables
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!!
Super UserIt'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...
PaulDBrown I'm confused.
Why would I ge this if I don't have an "issue" column in my patient's fall table? --- which I don't!
I simplified the fields in my tables, I don't have fields that are common to mulptiple tables except the location and date fields but this didn't resolve the issue.
- AlexisOlson
The first column, Units, only exists in the Patient Days table which does not filter the Patient Falls table. Hence there's no way to tell which falls are associated with which units and the measure sums over all of them.
The same holds true if you used Date from the Patient Days table instead of Date from the Calendar table.