DAX Measure that calculates differently based on another value

[rachaelwalker]

I created two measures that calculate the Utilization hours %. One department calculates it differently so I created a separate measure for their department. I have both values shown in a table but I only want one column for [Utilized %] depending on the employees department. I feel I could accomplish this with one measure but I am having a hard time filtering department in a measure

If department = "Service" then use [Utilized % Adjusted] else [Utilized %]

Measures

Utilized % = DIVIDE(SUM('Time Entry'[Hours Utilized]), SUM('Time Entry'[Hours Actual]), 0)

Utilized % Adjusted = DIVIDE(SUM('Time Entry'[Utilized Hours Service Desk]), SUM('Time Entry'[Hours Actual]), 0)

This is the results I am looking for

[Anonymous]

Hi @rachaelwalker,

I'd like to suggest you take a look at the following blog to know how to pick up the current row context value:

Using the SELECTEDVALUE function in DAX - SQLBI

The you can use compare with the current value and specific value and use in if statement to work as conditions.

Regards,

Xiaoxin Sheng

[Tom_Y]

Append that 2 tables, and make sure that [Hours Utilized] (of other department) and [Utilized Hours Service Desk] fall into the same column in the appended table.

[WinterMist]

@rachaelwalker 

Please try pulling the following measure onto your table visual.

Select Measure =
VAR CurrentDepartment = MAX(Table[Department])
VAR Result =
IF(
CurrentDepartment = "Service",
[Utlizized % Adjusted],
[Utilized %]
)
RETURN Result

Regards,

Nathan