JensejHelper V6 years agoSolvedTotal 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? Show MorePragati11 to Jensej6 years agoHi 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 to Jensej6 years agoHi 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 to Jensej6 years agoHi 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
Pragati11Super User6 years agoHi 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
Related contentconditional joinJoin the communitySpatial JoinCumulative TotalPower BI Pl 300 exam questions - Inner Join, Left outer Join and Right Join
