Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I need a bit of help witht the below formula.
I am trying to count number of employess who has worked more than 38 hours and less than 56 hours per week.
I also have a date table where i have a week number column and connected with employee table with the date column.
However as soon as i bring the measure in, it becomes blank
Any help is appreciated.
Thank you.
Solved! Go to Solution.
Proud to be a Super User!
Proud to be a Super User!
I will check it out. Thanks Vijay, Much Appreciated.
Hi Rubal_Islam,
If it blanks, it means that there is no employee that satisfy that filter context:
- Are you sure you have employees working with that hours in that weeks?
- Is [Hours Worked] a measure or a column? and is it the right data type?
Hi There,
I have changed the formula to show greater than 38 and lower than 56. it is still blank for 1 given week.
You can see on the right table that there are individual employees who has worked more than 38 hours that week.
I think my formula is not taking it to the individual employee level, rather doing it as a whole?
Could it be the weekNumber column is not accurate? Because in a year, there is a max of 52 weeks. Weeknumber 91 doesnt make sense, but maybe im missing a context here. 21st March should be week no 12.
If you have a pbix, I can have a look.
@Tutu_in_YYC @ weeknumber had it sum instead of don't summarize. that is not the issue here.
The measure looks right. The issue must be something else, eg a relationship/visual configuration
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |