Simple Sum of a measure not working

[electrobrit]

I have created a column for standard working hours where everyone is 40 hours except PersonA is 20 
My table is TimeDetail-fyi

2_Std Working Hours =

    SWITCH(

        TRUE(),

        SELECTEDVALUE(TimeDetail[full_name]) = "PersonA",20,40)

then when I add to column, I don't get a column total with it all added, instead just 40

Like

PersonA	20
PersonB	40
PersonC	40
Total	40	(should be 100)

So I added a measure to try to add them up. 
I'm sure it's a dax thing but why can't I do this?

4StdWorkingHours = SUM(TimeDetail[2Std Working Hours])
(Error: Column '2Std Working Hours' in table 'TimeDetail' cannot be found or may not be used in this expression.)

4StdWorkingHours = SUM(TimeDetail, TimeDetail[2_Std Working Hours])

(Error: Too many arguments were passed to the SUM function. The maximum argument count for the function is 1.)

how can I do this?

[v-yalanwu-msft · Accepted solution]

Hi, @electrobrit ;

You could try to change the meausre :

2_Std Working Hours = 
IF(
       MAX(TimeDetail[full_name]) = "PersonA",20,40)

Measure = SUMX(SUMMARIZE('TimeDetail',[full_name],"1",[2_Std Working Hours]),[1])

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[electrobrit]

That worked perfect! thank you

[MahyarTF]

Hi,

Did you create the measure or column ?

I create the same column with Calculate statement and it seems it is working properly :

2_Std Working Hours =

    CALCULATE(SWITCH(

        TRUE(),

        SELECTEDVALUE(Sheet226[Fullname]) = "PersonA",20,40))

Thanks for your Kudos.

Please select it as a solution if it helps you.

[hnguy71]

@electrobrit , your "calculated column" is likely a measure since within a calculated column we typically don't use SELECTEDVALUE.

A typical calculated column would look similar to this:

2_Std Working Hours = IF(TimeDetail[full_name] = "A",20, 40)

Then you can create a measure to sum up that new calculated column:

TotalHours := SUM(TimeDetail[full_name])

A calculated column would have this icon:

A measure would have this icon:

Let me know if that helps!

[electrobrit]

It was a measure. Thank you for that little lesson.
So when I sum it up, I have it filtered by date and it's bringing back all the hours. It seems like typically Power Bi would do this automatically but it doesn't. Is my measure incorrect?

[hnguy71]

@electrobrit can you try posting your new measure?

[electrobrit]

Thank you!

Column: 2_Std Working Hours = IF(TimeDetail[full_name]="PersonA", 20, 40)

Measure: 

4StdWorkingHours = SUM(TimeDetail[2_Std Working Hours])

[hnguy71]

Hi @electrobrit ,

Without seeing your model, I can only deduct that two possible reasons:

1. Your period_end_date field is not associated with your employee or resource type field.

2. Each employee has multiple records per period. For example, the first person has 17 records on 9/10/2022 while the last person has 4 records.

Could you supply a sample model?