Net debt increase/(decrease) Calculation

[Yrstruly2021]

I am trying to display row Net debt increase/(decrease) and assign the total value of:

Net Debt Increase/(Decrease) = 
VAR LeasesPrincipalRepaid = CALCULATE(
    SUM('Bracs'[Metric Value ($)]),
    'Bracs'[Metric] IN {"Leases principal repaid", "Change in cash net of overdraft"}
)
RETURN 
LeasesPrincipalRepaid

So that it display when using this code:

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,
        CALCULATE(
            SUM('ZTBR'[Amount in USD]),
            'ZTBR'[Roll_Up_Function] IN {
                "Cash flow from ops - management",
                "Cash flow from trading",
                "Profit before Brambles allocations Total",
                "Depreciation and amortisation",
                "IPEP expense",
                "Disposals & impairment of fixed assets",
                "Profit on disposal of pooling equipment",
                "Scrapped pooling equipment",
                "Impairment or valuation adjustment of pooling equipment",
                "Disposals or valuation adjustments of other fixed assets",
                "Other cash flow from trading adjustments",
                "Share-based payments expense",
                "Working capital mvts excl. provisions",
                "Debtor movements",
                "Creditor movements",
                "Inventory movements",
                "Prepayment movements",
                "Provision movements",
                "Change in capex creditors",
                "Brambles allocations not in mgt cash flow",
                "Interco interest and guarantee fees",
                "Interco cash flows",
                "Interco royalties",
                "Statutory reallocations",
                "Internal restructuring",
                "Interco dividends Total",
                "Change in interco balances",
                "Change in interco recharge clearing",
                "FX on interco debt",
                "Interco capital returned",
                "Interco cash flow adjustments",
                "Interest expense Total",
                "Interest revenue",
                "Interest received",
                "Lease interest"
            }
        ) + CALCULATE(
            SUM('Bracs'[Metric Value ($)]),
            'Bracs'[Metric] IN {
                "Pension plan adjustment",
                "Working capital - budget flex",
                "Pooling equipment additions",
                "Pooling equipment replacements",
                "Pooling equipment internal transfers",
                "Other PP&E additions",
                "Other PP&E replacements",
                "Other PP&E internal transfers",
                "Joint venture loans",
                "WDV pooling equip. disposals & write-offs",
                "Gain pooling equip. disposals & write-offs",
                "WDV other PP&E disposals",
                "Profit other PP&E disposals",
                "Discount unwind on long term provisions",
                "Tax paid",
                "Tax refunded",
                "Fiscal unity tax transfers",
                "Other cash flow items",
                "FX adjustments to cash flow",
                "Change in cash net of overdraft"
            }
        )
    )

Row should disply in the Decsription and the value to match is:

Please assist.

PBIXhttps://drive.google.com/file/d/1nSBwCKqxdEYe-pmK9UX2nPDV7XOpinfO/view?usp=sharing  

Please Note, all column descriptions can be found in table CashflowDiscriptions

[Anonymous]

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