So I have a calendar table with all the days and another column that has a DAX function doing this ( if is holiday or weekend equals 0 else 8), 8 is the standard daily work hours we have here in the company, this is working as expected, this column is called standard hours.
Aside from that, I have a table with all the employee and the hours they worked etc.
I've created a quick measure that is "sum of work hours divided by standard hours" in %, pretty simple right? But although the calculation is right, the visualization doesn't work as expected, see the image below:
So, this employee, worked 178 hours in April, in our company the standard is 5 days per week, 8 hours per day, so the math is:
5x8= 40 hours per week
4x40= 160 hours per month
So he worked 178 hours instead of the standard 160 hours for that month, this should be 110.8% (111% rounding up) but PBI is showing 10.8%.
I don't know what I'm doing wrong here.
@rafaelmpsantos the displayed numbers are right now but it broke the chart:
And if I try to do the same with "billable %", the results are very wrong, right now it should be 3% instead of 0.3% with the +1 it goes to 103%.
If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.