Net debt increase/(decrease) Calculation

Hi Yrstruly2021 ,

If I understand correctly, the issue is that you want to display row net debt increase/decrease. Please try the following methods and check if they can solve your problem:

1.Ensure that the measure is correctly calculating the sum.

2.Verify the table Relationships.

3.Test the measure in the following DAX formula.

New CombinedAmount = 
VAR SelectedCashFlowDescription = SELECTEDVALUE('CashflowDiscriptions'[description], "None")
VAR _TotalNetTaxPaid = CALCULATE([NetTaxPaid], ALL('CashflowDiscriptions'))
VAR _NetDebtIncreaseDecrease = CALCULATE(
    SUM('Bracs'[Metric Value ($)]),
    'Bracs'[Metric] IN {"Leases principal repaid", "Change in cash net of overdraft"}
)
RETURN
    SWITCH(
        TRUE(),
        SelectedCashFlowDescription = "Interco capital returned", 678,
        SelectedCashFlowDescription = "Net tax paid", _TotalNetTaxPaid,
        SelectedCashFlowDescription = "Leases principal repaid",
            CALCULATE(
                SUM('Bracs'[Metric Value ($)]),
                'Bracs'[Metric] = "Leases principal repaid"
            ),
        SelectedCashFlowDescription = "Net debt increase/(decrease)", _NetDebtIncreaseDecrease,
        // ... other cases ...
    )

Best Regards,

Wisdom Wu