Table Matrix rows repeat when add column

[nasirskardu]

I have simple data model as below 

I need to show No of Transactions fro each Tehsil. Tehsils with no transactions should show 0 entry. I created following two versions of measure:

No. of Transactions 2 = 
   var r = COUNTROWS(Transactions)
   return if (r = BLANK(), 0, r)

No. of Transactions = 
   var r = CALCULATE( COUNTROWS(Transactions), REMOVEFILTERS(District[District Name]))
   return if (r = BLANK(), 0, r)

when I use this measure with only Tehsil, both give correct answer

but when i add District column, it repeat rows:

Please help to solve issue.

[nasirskardu]

Thanks @DallasBaba for replying. 

I changed cross filter direction of relationship between District & Tehsil tables to "Both" but it did not work.

[DallasBaba]

Hi @nasirskardu 

The district is filtering on Tehsil. 
You need set the cross-filter cardinality to both directions so the Tehsil can filter on the district.

Please let me know if this work.

Thanks

Babatunde Dallas