Hi, @Anonymous
I used part of the sample data you provided below:
I corrected your DAX expression as follows:
Hours Above Threshold =
VAR ThresholdCount =
CALCULATE(
COUNTROWS(DataRecords),
FILTER(DataRecords, DataRecords[NumericValue] > 1000)
)
RETURN
DIVIDE(
ThresholdCount * 5, // 5 minutes per time slot
60 // Convert to hours
)The results are as follows:
In your Power BI, you are trying to count the number of time slots above a certain threshold (1000) and convert those time slots to hours. However, there are a couple of issues with your DAX expression that need to be fixed.
First, the COUNTROWS function returns the number of rows, not the number of time periods (if each row represents a 5-minute time period). In order to calculate the number of time periods above the threshold, you should use the COUNTROWS function directly, without dividing by 12 (since you haven't converted it to hours).
Then, in order to convert these time periods to hours, you need to know the length of time that each time period represents (5 minutes in your example), and you need to multiply the number of time periods by this length and then divide by 60 (since there are 60 minutes in an hour)
Best Regards,
hackcrr
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
I used part of the sample data you provided below:
I corrected your DAX expression as follows:
Hours Above Threshold =
VAR ThresholdCount =
CALCULATE(
COUNTROWS(DataRecords),
FILTER(DataRecords, DataRecords[NumericValue] > 1000)
)
RETURN
DIVIDE(
ThresholdCount * 5, // 5 minutes per time slot
60 // Convert to hours
)The results are as follows:
In your Power BI, you are trying to count the number of time slots above a certain threshold (1000) and convert those time slots to hours. However, there are a couple of issues with your DAX expression that need to be fixed.
First, the COUNTROWS function returns the number of rows, not the number of time periods (if each row represents a 5-minute time period). In order to calculate the number of time periods above the threshold, you should use the COUNTROWS function directly, without dividing by 12 (since you haven't converted it to hours).
Then, in order to convert these time periods to hours, you need to know the length of time that each time period represents (5 minutes in your example), and you need to multiply the number of time periods by this length and then divide by 60 (since there are 60 minutes in an hour)
Best Regards,
hackcrr
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Strange, I copy your table and measure and i got the result you are expecting. Make sure you don't have other filter in the side pane that might be causing you to get blanks.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
