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

7 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Jensej ,

     

    You can create a DAX as follows:

     

    Total = CALCULATE(SUM(bi_Ertrag[BetragFw]),  FILTER(ALLSELECTED(bi_Ertrag), bi_Ertrag[Konto_KontoNrFIB] = bi_Ertrag[Buchungen_KontoNrFIB]))

     

    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