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

amitchandak's avatar
amitchandak
Super User
6 years ago

Jensej , the formula seems correct, just make sure you select correct column names.

Select is from suggestions made by power bi

Jensej's avatar
Jensej
Helper V
6 years ago

Thanks for your help, now ive bumped into next problem..  amitchandak Pragati11 

 

So from my Total measure i wanted to how much sales i had for each day but it gives me the Total amount everywhere. 

 

I have conntected the salesdate from bi_ertrag with the date table so i was hoping it would work ? 

 

 

 

  • Pragati11's avatar
    Pragati11
    Super User
    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

    • Jensej's avatar
      Jensej
      Helper V
      6 years ago

      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? 

       

      • 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