Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I'm rebuilding a dashboard based on a 'dashboard' built using Excel.
In the original dashboard there is a table with a count of the number of staff who have recorded hours worked totalling between 4 specific ranges. I need to recreate this table below.
'NAA' is the staff member
Staff ('NAA' in this case) regularly record the number of hours they have worked in various categories, so there are multiple lines of data per user. The column for number of hours worked is a Decimal Number.
I figure I need to calculate the total hours worked per user and then get a count of how many users have recorded hours within each range. I'm just not sure where to start with this.
Any help would be greatly appreciated!
Hi, @Anonymous
First, you need to calculate the total number of hours worked by each user. You can do this by using DAX (Data Analysis Expression) to create a new measure in Power BI. Assuming your table is named, and the column for hours worked is , the measure might look like this:
Total Hours Worked = SUM(WorkHours[HoursWorked])
This measure summarizes all the working time entries for each user.
Next, create measures to calculate the number of employees in each specified range. For example, if one of the ranges is 15-100 hours, you can create a measure like this:
Count 0-20 Hours = CALCULATE(COUNTROWS(WorkHours), [Total Hours Worked] > 15, [Total Hours Worked] <= 100)
Repeat this step for each hour range and adjust the filter conditions accordingly.
Once you've set up a measure, you can easily visualize this data in Power BI.
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
189 | |
96 | |
67 | |
63 | |
53 |