Grouping lines of data together in a measure

[pauljohnson]

Hi,

I want to be able to create a measure, that will give me total hours worked (Weekly Hours), I have multiple lines with same WorkerID, Week No and Year but want to group hours worked based on all these being the same. 

It should only be displaying one row for each grouped set so in example below, just the lines with Weekly hours, I do get this, but the weekly hours seem to be way out on each line.

I have the below data

I was using this measure, but it doesn’t seem to be working

Weekly Hours = CALCULATE(SUM('HoursReports'[Hours Worked]),

FILTER(

ALL('HoursReports'),

'HoursReports'[Year] = EARLIER('HoursReports'[Year]) &&

'HoursReports'[Week No] = EARLIER('HoursReports'[Week No]) &&

'HoursReports'[WorkerID] = EARLIER('HoursReports'[WorkerID])

Am I doing something wrong, or is there an easier way of doing this?

[Greg_Deckler]

@pauljohnson Wouldn't you just put those three colums in the Axis and drill into it?

[pauljohnson]

@Greg_Deckler i need the weekly total as i need to drill down on the is column and cretae further measures on it, worker more than ?? hrs less then ??hrs for instance.

[Greg_Deckler]

@pauljohnson Hard to go farther on this without sample data I can copy and paste and what you are looking for in terms of output.