Problem with comulative sum

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