Forum Discussion

electrobrit's avatar
electrobrit
Post Patron
3 years ago
Solved

Multiple conditions

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?

 


  • electrobrit 

    Hi

    Try this.

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

    Thnak you.

     

2 Replies

  • Dinesh_Suranga's avatar
    Dinesh_Suranga
    Continued Contributor

    electrobrit 

    Hi

    Try this.

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

    Thnak you.

     

    • electrobrit's avatar
      electrobrit
      Post Patron

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