I use a matrix to show the percentage of billable hours and conditional formatting to show who is over or under a given percentage for each month.
I want to count how many workers are over 80% for each month and I tried to do it by adding the worker to my values in addition to "faktureringsgrad" which is the percentage of billable time. I think I only get the count of those who have a total billable hours over 80% and not the count per month. While the conditional formatting seems to work the way I want, the count doesn't.
Is there any way I can get my count of workers with a billable percentage of hours over 80% per month?
I have made a little spreadsheet with some relevant data in it and two reports which illustrates my problem. I want to count the number of workers with a specific % billable time and see the change over several months. So I want to hide the measure of billable time and show only the count of workers over (or under) 80% for each month. The conditional formatting does it right, but the filter on workers doesn't.
As you can see, the count is related to total billable time%, and not monthly.
Sorry. This is a good idea, but it doesn't solve my problem. Each worker has several timesheets and I guess you have just calculated the number of timesheets per month here. The correct count shoud be according to the number of lines with red colour in the above figure... So it is 2 in september, 1 in october and november and 2 in december. I think I need a formula to separate the billable% for each month. I will continue to try to solve this, but I would appreciate any good ideas as DAX formulaes are new to me.