Running total - Non date value

[Anonymous]

Hi,

How can I filter my TEST measure to start at the first months_since_reg value  and also exclude the blank value?

Regards,

Anders

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

You can create a calculated column [BetaltTotalt_column]

Here are the steps you can follow：

1. Create measure.

Flag =
var _table=SUMMARIZE(ALL('Table'),[month_since_reg],"1",[BetaltTotalt_measure])
var _last=CALCULATE(MAX('Table'[BetaltTotalt_column]),FILTER(ALL('Table'),[month_since_reg]=MAX('Table'[month_since_reg])-1))
var _rank=
minX(FILTER(ALL('Table'),'Table'[BetaltTotalt_column]<>BLANK()&&_last=BLANK()),[month_since_reg])
var _rabk1=IF(_rank=BLANK(),-99999,_rank)
return
IF(MAX('Table'[month_since_reg])<_rabk1,1,0)

2. Place [Flag] in Filter, set is=0, and apply filter.

3. Result:

Best Regards,

Liu Yang

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

[amitchandak]

@Anonymous , Replace all with allselected and try,

or you can force with filter

Cumm Sales =
var _max = maxx(allselected(date),date[date])

var _min= minx(allselected(date),date[date])
return
CALCULATE(SUM(Sales[Sales Amount]),filter(date,date[date] <=maxx(date,date[date]) && date[date] <=_max && && date[date] >=_min))

add other filters as per need