cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
electrobrit
Post Patron
Post Patron

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_0-1664566975469.png

 


1 ACCEPTED SOLUTION
Dinesh_Suranga
Responsive Resident
Responsive Resident

@electrobrit 

Hi

Try this.

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

Thnak you.

 

View solution in original post

2 REPLIES 2
Dinesh_Suranga
Responsive Resident
Responsive Resident

@electrobrit 

Hi

Try this.

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

Thnak you.

 

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

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.