Forum Discussion
Relationships issues
Hi MrTD,
You have unique values on a table and it's detailed in another 2 tables.
Let's take your sample data,
Table1 - ID(unique values)
Table2 - ID, Attribute
Table3 - ID, Travelled
Here is the issue,
Attribute and Travelled fields are having text values so we can't aggregate them.
Table2 is having 2 'a' values
Table3 is having 3 'a' values
obviously, the system can't detect the relationship between them. Suppose, any one of the tables has measures then it automatically aggregate it based on value 'a'
I hope I made it clear.
Let me know if you need further help.
Regards,
Siva
Hey SivaMani, thanks for the response.
I see. So Power BI doesn't detect the ID in the ID column even though I set up the relationship for it? A bit annoying hmm.
I've introduced a new column (all 1's) in my attributes table, and set the data type to whole number. By your comment shouldn't that mean that Power BI should aggregate these values and therefore the visual would be shown?
I've tried this and the same problem still persists so this probably isn't the case. Thanks!
