Incorrect total in bi-directional many-to-many relationship

[brian0782]

I have the below model which is many to many and bi-directional:

I have this calculated measure: Claim Amount Paid = CALCULATE(SUM('Claim Amounts'[Claims Paid]))

If I put UMR from the Binding Authority table into a matrix then each UMR is calculated correctly but the grand total is incorrect.

The total is actually the grand total from the Claims Amount table: 

What I require is the total to be based on the data that exists in Binding Authority table

I've tried changing the cross filter direction but that doesn't seem to work.

[amitchandak · Accepted solution]

@brian0782 ,

Try Like

sumx(Valeus(UMR[Binding Authority] ) , CALCULATE(SUM('Claim Amounts'[Claims Paid])))

[brian0782]

This is working well. Thanks 🙂