Forum Discussion
Running total - Non date value
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
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
2 Replies
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
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
