Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago
Solved

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 ISL...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Syndicate_Admin ,

     

    Maybe you should create table slicer about [ISLAND CT] and [Residence ISLAND]. You can refer to demo like below:

    DeparturesIslands = 
CALCULATE(
    SUM('Consulta1'[num_contratos]),
    'Consulta1'[RESIDENCE ISLAND] = SELECTEDVALUE('slicer'[RESIDENCE ISLAND]),
    'Consulta1'[RESIDENCE ISLAND] <> 'Consulta1'[CT ISLAND]
)
    IslandsInputs = 
CALCULATE(
    SUM('Consulta1'[num_contratos]),
    'Consulta1'[CT ISLAND] = SELECTEDVALUE('slicer2'[CT ISLAND]),
    'Consulta1'[CT ISLAND] <> 'Consulta1'[RESIDENCE ISLAND]
)

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Syndicate_Admin ,

 

Maybe you should create table slicer about [ISLAND CT] and [Residence ISLAND]. You can refer to demo like below:

DeparturesIslands = 
CALCULATE(
    SUM('Consulta1'[num_contratos]),
    'Consulta1'[RESIDENCE ISLAND] = SELECTEDVALUE('slicer'[RESIDENCE ISLAND]),
    'Consulta1'[RESIDENCE ISLAND] <> 'Consulta1'[CT ISLAND]
)
IslandsInputs = 
CALCULATE(
    SUM('Consulta1'[num_contratos]),
    'Consulta1'[CT ISLAND] = SELECTEDVALUE('slicer2'[CT ISLAND]),
    'Consulta1'[CT ISLAND] <> 'Consulta1'[RESIDENCE ISLAND]
)

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.