Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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!
Solved! Go to 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
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
@Anonymous
Can you please provide the sample data?
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.