DAX Measure Sum per machine and day

[Le_Backflip]

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!

[Anonymous · Accepted solution]

HI @Le_Backflip,

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

[talespin]

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]))

[sjoerdvn]

Have you tried removing that bookingdate from the ALLEXCEPT?

[Le_Backflip]

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