Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Creating a Measure for Missing Scheduled Time

Good day,   I am VERY new to measures and could use some guidance please. I have a table consisting of scheduled events by employees in the future. (I have a date table that maps week numbers to ea...
Need Help DAX measure
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Amit,

 

I tried this:

 

RemainingHours = Sumx(SUMMARIZE(ScheduleData, DateTable[Week], ScheduleData[Member_ID], "_1", SUM(ScheduleData[Hours_Sched])), 8-[_1])

 

and it didn't appear to work:

 

I'm sure it's something in my translation of your formula. I'm also curious what the "_1" parameter is doing?

 

Thank you,

Rob