Forum Discussion

MiguelSaldana77's avatar
MiguelSaldana77
Resolver I
8 years ago
Solved

Total Indicator without Date

Hi, I'm looking for a formula to calculate a Total of an Indicator excluding dimension of time.

 

I have a table that shows a Balance today for each Costumer and I make a Drill-Down see the correspondent bill.  I need to see the sum of charges and the payments for this each Bill.

 

Need Help
  • MiguelSaldana77's avatar
    MiguelSaldana77
    8 years ago

    This is the Final Formula

    Cumulative Cargos = CALCULATE ( SUM ( 'Indicadores Cartera'[Cargo] ),
                                       FILTER ( ALL( 'Cat Tiempo'[Fecha] ),'Cat Tiempo'[Fecha]<= MAX ('Cat Tiempo'[Fecha])))

     

    I had problems with the data but not because the formula.

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    Hi MiguelSaldana77

    I can't find how to calculate the sum of charges and the payments for this each Bill.

    Could you give more detailed information?

     

    Best Regrads

    Maggie

    • MiguelSaldana77's avatar
      MiguelSaldana77
      Resolver I
      8 years ago

      Ok, This is an Example

      I need always the Sum of The Charge for the Correspondent Bill

      The same for the Payments (for the correspondent bill)

       

      I want to exclude the date for the sum of Charges and Payments , of course I need Charges and Payments for the correspondent Bill.

       

  • MiguelSaldana77's avatar
    MiguelSaldana77
    Resolver I
    8 years ago

    This is the Final Formula

    Cumulative Cargos = CALCULATE ( SUM ( 'Indicadores Cartera'[Cargo] ),
                                       FILTER ( ALL( 'Cat Tiempo'[Fecha] ),'Cat Tiempo'[Fecha]<= MAX ('Cat Tiempo'[Fecha])))

     

    I had problems with the data but not because the formula.