Forum Discussion

MiguelSaldana77's avatar
MiguelSaldana77
Icon for Resolver I rankResolver 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.

MiguelSaldana77's avatar
MiguelSaldana77
Icon for Resolver I rankResolver 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.