Inputs, Outputs and Differences

Hello everyone

I am making a balance scorecard, with entries and exits of the municipalities, and then the difference between the two.

For this I have a table with three fields: CT ISLAND, RESI ISLAND, Counter. This calculates me between the two communes of Municipalities how many it has. That is, each row is the result of MunicipalityCT to MunicipalityResi or vice versa, and it may be the case that it has different results for the same combination of municipalities:

The fact is that when I try to do the subtraction, the difference for a municipality between the two fields comes out to zero, since it only detects one of them and not both.

The measurements I use to calculate the entrances and exits are:

IslandsInputs=CALCULATE(

SUM('Consulta1'[num_contratos]);

Query1[ISLAND CT] = SELECTEDVALUE(Query1[ISLAND CT]);

'Consultation1'[CT ISLAND] <> 'Consultation1'[Residence ISLAND]

)

DeparturesIslands=

CALCULATE(

SUM('Consulta1'[num_contratos]);

Query1[RESIDENCE ISLAND] = SELECTEDVALUE(Query1[Residence ISLAND]);

'Consultation1'[Residence ISLAND] <> Consultation1[CT ISLAND]

)

I hope you can help me to see the light. Thank you very much in advance