Forum Discussion

MrTD's avatar
MrTD
Frequent Visitor
8 years ago

Relationships issues

Setup: I have a unique identifier in my 'Person' table labelled ID. These identifiers exist in two other tables 'Person Attributes' and 'Person Events' but are not unique.  I have a relationship set ...
Need Help
MrTD's avatar
MrTD
Frequent Visitor
8 years ago

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!

SivaMani's avatar
SivaMani
Resident Rockstar
8 years ago

MrTD,

 

Try Merge Queries. It will help you to achieve this 

  • MrTD's avatar
    MrTD
    Frequent Visitor
    8 years ago

    SivaMani,  thanks once again!

    This isn't optimal with a dataset that has millions of rows with various columns say. This surely would require a large amount of memory which again, isn't optimal! Thanks