Multiple conditions

[electrobrit]

I am trying to get a table where I have standard working hours, Total PTO, Adjusted Hours (Std hours-PTO), then a final column where if the resource type is "Contractor" or a specific person, ex. "Andy", it equals Hours Worked.
Otherwise, it's the Adjusted Hours

I have done most measures in a Key measures table. Then I have a detail table where I'm trying to do the conditional column (Contractor or Andy=hours worked, else Adjusted Hours) with the measures and detail. 
I've tried

Column 2 = SWITCH(

    TRUE(),

    'TimeDetail'[full_name]="Andy"|| TimeDetail[ResourceType]="Contractor", SUMX('--Key Measures',[TotalHoursWorked]),

 [AdjustedHours]

)

I've tried this and get same results

Column 2 = SWITCH(

    TRUE(),

    TimeDetail[ResourceType]= "Contractor", [TotalHoursWorked],

    TimeDetail[full_name]= "Andy", [TotalHoursWorked],

    TimeDetail[ResourceType]= "Employee", [AdjustedHours])

I've looked at the data and it's not the data, but some of the column values (conditonal column) are off.
In the screenshot, they should equal the total hours worked columnn 
Is there another way to do this conditional column or can anyone tell what might be wrong?

[Dinesh_Suranga · Accepted solution]

@electrobrit 

Hi

Try this.

Column 2 =IF(SELECTEDVALUE(TimeDetail[full_name])= "Andy", [TotalHoursWorked],
          IF(SELECTEDVALUE(TimeDetail[ResourceType]) = "Contractor", [TotalHoursWorked],[AdjustedHours]))

Thnak you.

[electrobrit]

added as a measure in the key measures table and worked perfectly. THANK YOU