Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • pawel1's avatar
    pawel1
    8 years ago

    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

pawel1's avatar
pawel1
Kudo Kingpin
8 years ago

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.