Forum Discussion
Adding column that summarizes values in matrix
I assume your data is in tabular (not pivot) format. if not, you need to unpivot it, so it looks like this:
then you can play with the data
1. build matrix with Hours
2. add a measure counting months when an employee worked over 40 hours:
More than 40 hours =
CALCULATE ( COUNT ( Hours[Hours]), Hours[Hours] > 40)hope it helps
I assume your data is in tabular (not pivot) format. if not, you need to unpivot it, so it looks like this:
then you can play with the data
1. build matrix with Hours
2. add a measure counting months when an employee worked over 40 hours:
More than 40 hours =
CALCULATE ( COUNT ( Hours[Hours]), Hours[Hours] > 40)
hope it helps
Thank you pawel1, I followed your tip but for some reason the measure doesn't return anything and it just display blank.
Check:
1) HoursCount = CALCULATE(count(v_TimeKeeping[Hours]),v_TimeKeeping[Hours]>40)
2) The data is not in pivot format
sorry nevermind I just had a problem with the filter.
Is there any way to do this count for pivoted data?
my data table has the hours per employee per day so I was using the "bin" function to group the dates.