Sum on combined tables incorrect

[Sbudd]

Hi 

Im having a little difficulty with the below, I would like to combine 2 tables together that have 2 things in common Date and Default Channel Grouping.

Top table is a Summarized viz of my orders table (1), Bottom Table is summarized viz of my Sessions Table (2) and as you can see when i drop in Session to the top viz its the same values all the way down, when should be like the bottom table.

Any help would be hugely appreciated!

Thanks in advance 

[selimovd · Accepted solution]

Hey @Sbudd ,

you can create a measure that has to connect from one table to the other and set the relationship in this measure to bidirectional with the CROSSFILTER function.
To test the result without a measure you could also quickly change the filter direction to bidirectional to check if that is the result you want.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Sbudd]

Thanks Denis!! You're a star!