Forum Discussion
Total with a join
Hi Jensej ,
Can you try changing your relationship direction to "BOTH" and check if this works?
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Pragati11 Thanks a lot, but i dont understand why i have to do this? It stand i should not use this if i have unique values in one of the tables and in my date tables the dates are unique or not?
Now next problem: 🙂
If i add a new filter to the visual where i say i just want to see the Totals each day in the first quarter only on the Konto_KontoNrFIB IN (340100,340200) i just see the last day with the Total?
Hi Jensej ,
The reason why you have make this relationship BOTH is - You are trying to get a measure value from a different related table. So, when you select a date field from your DATE table, it needs to filter your other table to get the measure value correct.
You can refer following article on why direction of a relationship is important:
https://radacad.com/what-is-the-direction-of-relationship-in-power-bi
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati