Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cumulative count measure

  I looking to creating a cumulative measure on the patient count. Patient Count column is    count(table[patienid])    
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    5 years ago

    Hi Anonymous 

     

    Try this one:

    RunningTotal1 = 
VAR __year = MAX(TrendingTable[Date_Start_Statusdate].[Year])
RETURN
CALCULATE(
    count(TrendingTable[vw_AccrualsList.patientId]),
    FILTER(allselected(TrendingTable), TrendingTable[Date_Start_Statusdate] <= MAX(TrendingTable[Date_Start_Statusdate]),values(TrendingTable(Year))
    )
)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Anonymous - Can you just use the Running Total Quick Measure that is built into the Desktop? In Fields, click the ellipses next to Patient Count and choose Quick Measure and then Running Total.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

It gives me the running total on years I want it on month jan 2018,feb 2018 etc

RunningTotal = 
CALCULATE(
	COUNTA('TrendingTable'[vw_AccrualsList.patientId]),
	FILTER(
		ALLSELECTED('TrendingTable'[vw_AccrualsList.StatusDate].[Year]),
		ISONORAFTER('TrendingTable'[vw_AccrualsList.StatusDate].[Year], MAX('TrendingTable'[vw_AccrualsList.StatusDate].[Year]), DESC)
	)
)