Matrix Visual is not totalizing values in a cash flow

[Anonymous]

Hey there!

Could someone help me? I'm trying to make a realized cash flow and i've already created a measure with 4 variables: 
- Start balance
- inputs 

- outputs

- end balance

The end balance is not working and I don't now why, but besides that, when I put the measure into matrix visual, I guess it should sum the start balance, inputs and outputs, wich should result in an end balance.

My measure:

var SALDOINICIAL = CALCULATE ( [_.SALDOFINAL],DATEADD('Calendário'[Date],-1,DAY))

var SALDOFINAL =

CALCULATE (

SUM ( Movbancos[E5_VALOR] ),

Movbancos[E5_RECPAG] = "01. Entradas",

ALL ( Estrutura ),

ALL ( 'Calendário' ),

FILTER (

ALL ( Movbancos[E5_DATA], Movbancos[E5_CONTA] ),

Movbancos[E5_DATA] <= MAX ( 'Calendário'[Date] ) && Movbancos[E5_CONTA] IN VALUES (Estrutura[DESCRIÇÃO])

)

)

- CALCULATE (

SUM ( Movbancos[E5_VALOR] ),

Movbancos[E5_RECPAG] = "01. Entradas",

ALL ( Estrutura ),

ALL ( 'Calendário' ),

FILTER (

ALL ( Movbancos[E5_DATA], Movbancos[E5_CONTA] ),

Movbancos[E5_DATA] <= MAX ( 'Calendário'[Date] ) && Movbancos[E5_CONTA] IN VALUES (Estrutura[DESCRIÇÃO])

)

)

var ENTRADAS = CALCULATE(SUM('Movbancos'[VALOR_FINAL]),'Movbancos'[E5_RECPAG]="01. Entradas")+0

var SAIDAS = CALCULATE(SUM('Movbancos'[VALOR_FINAL]),'Movbancos'[E5_RECPAG]="02. Saídas")+0

return

SWITCH (

SELECTEDVALUE ( Estrutura[DESCRIÇÃO] ),

"01. Entradas", ENTRADAS,

"02. Saídas", SAIDAS,

"00. Saldo Inicial", SALDOINICIAL,

"03. Saldo Final",SALDOFINAL

)

The result:

[Anonymous]

@Greg_Deckler , thank you for the support and the explanations. I realized that I forgot to sum start balance, inputs and outputs in the variable "end balance".
See below the measure:

var SALDOINICIAL = CALCULATE ( [_.SALDOFINAL],DATEADD('Calendário'[Date],-1,DAY))

var SALDOFINAL =

CALCULATE (

SUM ( Movbancos[E5_VALOR] ),

Movbancos[E5_RECPAG] = "01. Entradas",

ALL ( Estrutura ),

ALL ( 'Calendário' ),

FILTER (

ALL ( Movbancos[E5_DATA], Movbancos[E5_CONTA] ),

Movbancos[E5_DATA] <= MAX ( 'Calendário'[Date] ) && Movbancos[E5_CONTA] IN VALUES (Estrutura[DESCRIÇÃO])

)

)

- CALCULATE (

SUM ( Movbancos[E5_VALOR] ),

Movbancos[E5_RECPAG] = "01. Entradas",

ALL ( Estrutura ),

ALL ( 'Calendário' ),

FILTER (

ALL ( Movbancos[E5_DATA], Movbancos[E5_CONTA] ),

Movbancos[E5_DATA] <= MAX ( 'Calendário'[Date] ) && Movbancos[E5_CONTA] IN VALUES (Estrutura[DESCRIÇÃO])

)

)

var ENTRADAS = CALCULATE(SUM('Movbancos'[VALOR_FINAL]),'Movbancos'[E5_RECPAG]="01. Entradas")+0

var SAIDAS = CALCULATE(SUM('Movbancos'[VALOR_FINAL]),'Movbancos'[E5_RECPAG]="02. Saídas")+0

return

SWITCH (

SELECTEDVALUE ( Estrutura[DESCRIÇÃO] ),

"01. Entradas", ENTRADAS,

"02. Saídas", SAIDAS,

"00. Saldo Inicial", SALDOINICIAL,

"03. Saldo Final", SALDOINICIAL + ENTRADAS + SAIDAS

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

Could you pls provide a sample .pbix file for test?

Remember to remove the confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[Greg_Deckler]

@Anonymous This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907