Problem with comulative sum

[Anonymous]

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!

[v-yangliu-msft · Accepted solution]

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

[rajulshah]

@Anonymous 

Can you please provide the sample data?