Forum Discussion
Adding column that summarizes values in matrix
Hi All, First post here, tried Googling for a solution but no luck. I have a matrix visual that display Employee (row) and the number of hours worked per month (column), for 12 months, like b...
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.