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 corresp...
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.

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.