Fill blanks with previous state in accumulative total

[aguuzdo]

Hi, I'm trying to build a funnel with the ammount of persons that where in each group of tenure groups in weeks.
The problem is that if I didn't have a change in one of the groups, I get a blank value while I should get the previous value:

For example, tenure group 7 in the image should be the previous value 18, not blank.

This is my measure:

Accumulated tenure groups =

VAR UncumulativeTotal = CALCULATE(COUNT('Database'[Tenure (groups)]),'Database'[Tenure (groups in number format)]>=MAX('Database'[Tenure (groups in number format)]))

RETURN

IF(ISBLANK(COUNT('Database'[Tenure (groups)])),BLANK(),UncumulativeTotal)

[v-rongtiep-msft · Accepted solution]

Hi @aguuzdo ,

Please modify your formula.

Accumulated tenure groups =

VAR UncumulativeTotal = CALCULATE(COUNT('Database'[Tenure (groups)]),'Database'[Tenure (groups in number format)]>=MAX('Database'[Tenure (groups in number format)]))

RETURN
IF(ISBLANK(COUNT('Database'[Tenure (groups)])),CALCULATE(MAX('Table'[TEenure]),FILTER(ALL('Table'),'Table'[date]=SELECTEDVALUE('Table'[date])-1)),MAX('Table'[TEenure]))

I have create a simpe sample, please refer to it.

If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output and your desired output with more details.

 Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.