Every visualisation shows same value despite relationship

[Anonymous]

Dears,

I have a simple data model with 2 tables:

- one containing project ID's and their sold turnover

- one containing that same project ID and a creation date

I now want to create a visual showing me the turnover per month, but it returns the same value for every month. I'm lost as to what I do wrong.

[Anonymous]

Hi @VahidDM 

That's indeed the solution, thanks! Could you explain to me what's the reasoning behind this?

[VahidDM · Accepted solution]

Hi @Anonymous 

Whas is the Cross Filter Diresction of that relationship? Have you set that on Both and check the report?

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/