Duplicate result while adding a measure

I have the following tables  :

• Dim Client
• Dim Contract
• Dim Account
• Fact Ledger
• d_balance_mappings

   

  the relationships :

  • Dim Client to Dim Contract 1 to many / Cross filter direction Single from Dim Client to Dim Contract
  • Dim Client to Dim Account : 1 to many / Cross filter direction Single from Dim Client to Dim Account
  • Dim Account to Fact Ledger : 1 to many / Cross filter direction Both
  • Fact Ledger to d_balance_mappings : many to 1 / Cross filter direction both

     

    and I have these measures :

     

Account Principal Amount = CALCULATE([Ledger Total Amount],d_balance_mappings[Transaction Name] = "Account Principal Amount")


Ledger Total Amount = SUM( 'Fact Ledger'[Ledger Amount] )

When I build a table visual containing :

• Client Id from Dim Client
• Contract Type from Dim Contract
• Client Name from Dim Client
• Account Principal Amount (the measure)

   

  Client id       Contract Type    Client name      Ledger Amount
  123               Freelance            ABC                  1171378
  123               CDI                       ABC                  1171378

   

  So as you see I have duplicate rows it is like a cartesian product while for this Client Id the contract type is only Freelance.