Adding a Fix value to a calculation.

[Yrstruly2021]

I am trying to add a fixed value "Interco capital returned" 678 to a dax total calculation.

To get the fix value i used

New CombinedAmount3 = 

VAR SelectedCashFlowDescription = SELECTEDVALUE('CashflowDiscriptions'[description], "None")

VAR _TotalNetDept = CALCULATE([Net debt increase/decrease], ALL(CashflowDiscriptions))

VAR _TotalNetTaxPaid = CALCULATE([NetTaxPaid], ALL(CashflowDiscriptions))

VAR _TotalIntercoCashFlows = CALCULATE([IntercoCashFlows], ALL(CashflowDiscriptions))

VAR _LeasesPrincipalRepaid = CALCULATE(

    SUM(Bracs[Metric Value ($)]),

    Bracs[Metric] = "Leases principal repaid"

)

RETURN

    SWITCH(

        TRUE(),

        SelectedCashFlowDescription = "Interco capital returned", 678,

        SelectedCashFlowDescription = "Net debt increase/(decrease)", _TotalNetDept, 

        SelectedCashFlowDescription = "Net tax paid", _TotalNetTaxPaid,

SelectedCashFlowDescription = "IntercoCashFlows", _TotalIntercoCashFlows,

        SelectedCashFlowDescription = "Leases principal repaid", _LeasesPrincipalRepaid,

        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"

            }

        )

    )

and it does display correctly:


I eant to include this value now to a total calculation in dax:

IntercoCashFlows = 

CALCULATE(

    SUM('ZTBR'[Amount in USD]),

    'ZTBR'[Roll_Up_Function] IN {

        "Interco interest and guarantee fees",

        "Interco royalties",

        "Statutory reallocations",

        "Internal restructuring",

        "Interco dividends Total",

        "Change in interco balances",

        "Change in interco recharge clearing",

        "FX on interco debt",

        "Interco capital issued",

        "Interco capital returned",

        "Cash balances transfer on merging entities",

        "Interco cash flow adjustments",

        "Cashflow budget flex adjustment"

    }

)

This row does not appear in the display of the above dax, it might be because it is not finding this row in SUM('ZTBR'[Amount in USD]),

            'ZTBR'[Roll_Up_Function] IN , but its in table CashFlowDescriptions which is only the reference table.

Please assist. PBIX [https://drive.google.com/file/d/1nSBwCKqxdEYe-pmK9UX2nPDV7XOpinfO/view?usp=sharing  ](https://drive.google.com/file/d/1nSBwCKqxdEYe-pmK9UX2nPDV7XOpinfO/view?usp=sharing  )

[Anonymous]

Can you please help here!!

Hi All, I need help on the totals where i have 2 tables and i jant to add Jan totals line by line to Feb Totals so that in Feb we have 492 as subtotals and segment wise it should be 

12

12

377 & 91,

regards

[Anonymous · Accepted solution]

Hi @Yrstruly2021 ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Dangar332]

hi, @Yrstruly2021 

as i understood your problem you wanna try to get total as fixed value

see below as data 

same problem like you total= 300 but actual is 5200

but implement measure 3 as below

Measure 3 = 
IF(
    ISINSCOPE('Table'[product]),
    MIN('Table'[value]),
    CALCULATE(sum('Table'[value]),ALL())
)