When using a calculate to filter a sum I get double values

[JoyceW]

I have a table with general ledger account numbers and the values of the transactions. 

for example:

reknr	bdr_val
2403	-31,55
2403	-34,58
2403	-310
2403	-28,98
2403	-29,26
2403	-29,26
2403	-26,34

There is another table with categories per general ledger account. 

So 2403 is linked to category "liquide middelen"

I want to sum all values of all general ledger accounts with the category "liquide middelen"

I made the following colum: 

current Ratio = CALCULATE(SUM(GrootboekMutaties[bdr_val]);GrootboekCategorieNiveau2[GrootboekCategorieOmschrijvingNiveau2]="liquide middelen")

It works when there are no rows with the same value. But there are some rows that have the same value, it counts those twice. How do I fix this? It feels like this should be easy, but it's not. 😞

reknr	bdr_val	current Ratio
2403	-31,55	-31,55
2403	-34,58	-34,58
2403	-310	-310
2403	-28,98	-28,98
2403	-29,26	-58,52
2403	-29,26	-58,52
2403	-26,34	-26,34

[v-chuncz-msft · Accepted solution]

@JoyceW ,

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Labour-Efficiency/m-p/565837#M267006