Forum Discussion

drnareshchauhan's avatar
drnareshchauhan
Helper I
6 years ago
Solved

cumulative total

  I am trying to do covid cases analysis, but stuck with the problem of cumulative total . when I apllied cumulative formula as discribe here , cumulative mesure   Running Total MEASURE = CALC...
Need Help
  • drnareshchauhan's avatar
    drnareshchauhan
    6 years ago

    hello !

    this is how it worked

     

    Districtwise Cumulative Death = CALCULATE(SUM('confirmed death'[new confirmed death]),FILTER(ALL('confirmed death'),'confirmed death'[DATE OF OUTCOME]<=MAX('confirmed death'[DATE OF OUTCOME]) && 'confirmed death'[DISTRICT]=MAX('confirmed death'[DISTRICT])))
     
    thanks all
drnareshchauhan's avatar
drnareshchauhan
Helper I
6 years ago

hello !

this is how it worked

 

Districtwise Cumulative Death = CALCULATE(SUM('confirmed death'[new confirmed death]),FILTER(ALL('confirmed death'),'confirmed death'[DATE OF OUTCOME]<=MAX('confirmed death'[DATE OF OUTCOME]) && 'confirmed death'[DISTRICT]=MAX('confirmed death'[DISTRICT])))
 
thanks all