Total Indicator without Date

[MiguelSaldana77]

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.

[MiguelSaldana77 · Accepted solution]

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]

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]

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.