topic Re: DAX Measure Sum per machine and day in DAX Commands and Tips

DAX Measure Sum per machine and day

Le_Backflip — Mon, 22 Jan 2024 08:51:46 GMT

Hi,

I have a list with the times of every completed Job (machinehours) for every machine (name) in our plant.

I tried to create a measure to give me the sum of machinehours for each machine per day.

= CALCULATE(SUM('job_list'[machinehours]);ALLEXCEPT('job_list';'job_list'[name];'job_list'[bookingdate]))

Can someone help me with the correct formula and explain me why this is only giving me the sum of machinehours per machine ?

Thanks!

sjoerdvn — Mon, 22 Jan 2024 09:06:31 GMT

Have you tried removing that bookingdate from the ALLEXCEPT?

Le_Backflip — Mon, 22 Jan 2024 09:16:19 GMT

Then I get the sum of machinehours per machine for the whole dataset and not per day.

talespin — Mon, 22 Jan 2024 14:08:14 GMT

Can you please share the result with your original formula.

This removes all filters on table except [name] and [bookingdate]. So it should give you total by booking date and name.

CALCULATE(SUM('job_list'[machinehours]);ALLEXCEPT('job_list';'job_list'[name];'job_list'[bookingdate]))

Anonymous — Thu, 25 Jan 2024 07:34:37 GMT

Perhaps you can try to use the following measure fomraul if it suitable for your requirement:

formula = CALCULATE ( SUM ( 'job_list'[machinehours] ), ALLSELECTED ( 'job_list' ), VALUES ( 'job_list'[name] ), VALUES ( 'job_list'[bookingdate] ) )

Regards,

Xiaoxin Sheng