Conectores multiples

EstanisMiret You can form multiple relationships between tables and use the USERELATIONSHIP function within the CALCULATE function to control which relationship is used. So you could create two relationships between the tables like name to customer and name to partner and depending on which one you want to use then you could control the behavior. 

Hi EstanisMiret 

 Configure 2 relationships between the tables, 1 active and 1 inactive:

Active - Company[Name] - Transactions[Client]

Inactive - Company[Name] - Transactions[Partner]

Add 2 measures to your report:

Client transaction total = SUM(Transactions[Amount])

Partner transaction total = CALCULATE(SUM(Transactions[Amount]),
                            USERELATIONSHIP(Company[Name], Transactions[Partner]))

You will get the following results:

--------------------------------

I hope this helps, please give kudos and mark as solved if it does!

Connect with me on LinkedIn.

Subscribe to my YouTube channel for Fabric/Power Platform related content!