Goal Seek/ add total of column to row

[Anonymous]

Hi. So i have a simple matrix with different periods and a balance sheet. 

What i want is basically a goal seek: IF the total <> 0 , then add the value to this account row: Consolidado[Conta SAP] = 2610200100.

With this example: the 15.400.538 would add to the row where [Conta SAP] = 2610200100 is thus turning  total = 0.

Thanks in advance 🙂

[v-rongtiep-msft · Accepted solution]

Hi @Anonymous , 

I have create a simple sample, please refer to it to see if it helps you.

Create measures.

Measure_2 =
VAR SUMALL =
    SUMX ( ALL ( 'Table' ), 'Table'[Value] )
VAR _SUMX261 =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            ALL ( 'Table' ),
            MONTH ( 'Table'[date] ) = SELECTEDVALUE ( 'Table'[_MONTH] )
                && 'Table'[ID] <> "2610200100"
        )
    )
VAR _261 = _SUMX261 * -1
VAR _IF =
    IF (
        SUMALL <> 0
            && MAX ( 'Table'[ID] ) = "2610200100",
        _261,
        MAX ( 'Table'[Value] )
    )
RETURN
    _IF

Measure =
IF ( HASONEVALUE ( 'Table'[ID] ), [Measure_2], SUMX ( 'Table', [Measure_2] ) )

If I have misunderstood your meaning, please provide your desired output and your pbix without privacy information.

Best Regards

Community Support Team _ Polly

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