Duplicate result while adding a measure

[AmiraBedh]

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.

  

[Anonymous]

Hi @AmiraBedh 

@miTutorials Thank you very much for your prompt reply.

Can you tell me if your problem is solved? If yes, please accept it as solution.

Regards,

Nono Chen

[miTutorials · Accepted solution]

Change the filter direction between Dim Client and Dim Contract to Both and give it a try!