Forum Discussion

Jensej's avatar
Jensej
Helper V
6 years ago
Solved

Total with a join

Hello   How can i make a measure with the Total BetragFw only on the fields where Buchungen_KontoNrFIB and Konto_KontoNrFIB is equal?      
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    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's avatar
Pragati11
Super User
6 years ago

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

Jensej's avatar
Jensej
Helper V
6 years ago

Pragati11  Ok i see, i edited my latest post. Have another Problem 🙂 I really appreciate your help 🙏