Hi, @ervarble
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, @ervarble
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
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
