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 response time is the count of the hours that fall within the Bins column. I tried all possible formula but I cant seem to get a comulative count. I am very new at PBI and I will appreciate any help that I can get. Thanks!
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
2 Replies
Anonymous
Can you please provide the sample data?
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
