Cash flow imbalance n DAX

[Yrstruly]

@mspanic

Please assist. The row Cash flow imbalance should be 0 as indicated in the screenshot, below.

I am not getting a 0. Cash flow imbalance Is made up of calculations/formulas as seen in the Excel/Sheet file Column K, https://docs.google.com/spreadsheets/d/1ubo9TAz2zzCpKbfO5SFBMjFLgjFtUxhY/edit?usp=sharing&ouid=104129043494164133703&rtpof=true&sd=true

To get the formula click in column K on the value:

PBIX: https://drive.google.com/file/d/1-wHE0e50nSM9-wSq4dTxStDX58APO_MI/view?usp=sharing
I am also getting a repeat of the amount 201256612.25, I don’t know why. Some figures tend to differ when i work connected to the Live source on the Server as opposed to the downloaded version for Desktop

[mspanic]

@Yrstruly ,

For both Excel and PBIX - Access is denied.

So my advice is - use similar logic as you did at:

Adding Rows to get a Total

@mspanic Thank you. Your code [image] Omitted now this row in this dax BlockquoteNet Debt Increase/(Decrease) = VAR LeasesPrincipalRepaid = CALCULATE( SUM(‘Bracs’[Metric Value ($)]), ‘Bracs’[Metric] IN {“Leases principal repaid”, “Change in cash net of overdraft”} ) RETURN LeasesPrincipalRepaid Also this calculation is suppose to read data from two sources. Although the second source dont have any values for the rows mentioned, i still would like to see them in the final dax. They …

Regarding different figures - Live source vs downloaded version - it usually happens when figures changes (after downloaded version refresh).

Good luck.