Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Problems with model and relationships

I am having the following problem:

Having metrics from GA and from our own dwh. Both have channel Id which I have a lookup for, and both have a date and I am linking both tables on date.

 

But in relationships I can only establish relationships between GA nad Invoices on Date, OR GA and channels, I cannot do both.

 

How can I change it? I want to insert a slicer where I select channel and date range and it gives me numbers from both sources.

 

Relationships I have so far are 'Both' ways. Thanks!

 

 

Need Help

4 Replies

  • Nithinr's avatar
    Nithinr
    Resolver III
    2 years ago

    Anonymous  Have you tried making relationship between channel and invoice cross filter direction both?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks Nithinr I did change them to Both, then changed all to Single and ways and getting the same error: 

     

  • Nithinr's avatar
    Nithinr
    Resolver III
    2 years ago

    sorry for late reply, do one thing remove relation between googlemetrics and channels.  Make relation between channels and invoices both ways and channel metrics and invoices both ways. If you can share pbix that would be great