Forum Discussion
Problem with comulative sum
Hello, I am trying to make a comulative count based on the Response time (hrs). As you can see, the "Bins column" are hours (ex. 0-4 hrs). I also created an index for the bins and the count of respo...
Hi Anonymous ,
Here are the steps you can follow：
1. Create calculated table.
Table 2 = var _tabel1=SUMMARIZE('Table', 'Table'[Bin_No],'Table'[Bins], "count of ResponseTime_BDNotified(hours)", COUNTX( FILTER(ALL('Table'),'Table'[Bins]=EARLIER('Table'[Bins])),[ResponseTime_BDNotified(hours)]) ) var _table2= ADDCOLUMNS( _tabel1,"Sum", SUMX( FILTER(_tabel1,[Bin_No]<=EARLIER('Table'[Bin_No])),[count of ResponseTime_BDNotified(hours)])) return _table22. Create measure.
Flag= SUMX( FILTER( 'Table 2',[Bins] = MAX('Table'[Bins])),[Sum])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
Hi Anonymous ,
Here are the steps you can follow：
1. Create calculated table.
Table 2 =
var _tabel1=SUMMARIZE('Table',
'Table'[Bin_No],'Table'[Bins],
"count of ResponseTime_BDNotified(hours)",
COUNTX(
FILTER(ALL('Table'),'Table'[Bins]=EARLIER('Table'[Bins])),[ResponseTime_BDNotified(hours)])
)
var _table2=
ADDCOLUMNS(
_tabel1,"Sum",
SUMX(
FILTER(_tabel1,[Bin_No]<=EARLIER('Table'[Bin_No])),[count of ResponseTime_BDNotified(hours)]))
return
_table2
2. Create measure.
Flag=
SUMX(
FILTER(
'Table 2',[Bins] = MAX('Table'[Bins])),[Sum])
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