topic Re: Grouping lines of data together in a measure in DAX Commands and Tips

Grouping lines of data together in a measure

pauljohnson — Tue, 03 Aug 2021 16:43:11 GMT

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?

Re: Grouping lines of data together in a measure

Greg_Deckler — Tue, 03 Aug 2021 18:17:17 GMT

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

Re: Grouping lines of data together in a measure

pauljohnson — Wed, 04 Aug 2021 09:11:28 GMT

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.

Re: Grouping lines of data together in a measure

Greg_Deckler — Wed, 04 Aug 2021 12:52:56 GMT

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.