Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Matrix Visual is not totalizing values in a cash flow

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:

 



Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    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!

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      v-kelly-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      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!