Calculate column returning multiple values in if condition

[rathimd]

Hi ,

1) Using Column 

When I am passing column else condition in below query it is giving returing me single value.

Mark-up Cost Actual - Salary =

IF(

     RELATED(

         Employees[Rank Code]

         )

         = 9050,

         DIVIDE(

             SUM('Time & Billing'[PROD_TIME_AMT]),

             SUM('Time & Billing'[PROD_TIME_HRS])

             ),

Related(Employees[Actual Rate])

2)Using Measure

When I am passing measure in else condition in below query it is returing multiple value

Mark-up Cost Actual - Salary 1 =

IF(

     RELATED(

         Employees[Rank Code]

         )

         = 9050,

         DIVIDE(

             SUM('Time & Billing'[PROD_TIME_AMT]),

             SUM('Time & Billing'[PROD_TIME_HRS])

             ),

[Labor Rate Salary]))

This is the measure and it is returning correct value 

[Labor Rate Salary] =

 ((SUM(Employees[Salary($)]) * [STD Hrs (%)])/[Total Charge Hours]

)

[rathimd]

@amitchandak @Greg_Deckler @PaulDBrown @Shaurya @lbendlin 

[amitchandak · Accepted solution]

@rathimd , try like

IF(
Max( Employees[Rank Code] ) = 9050,
DIVIDE(
SUM('Time & Billing'[PROD_TIME_AMT]),
SUM('Time & Billing'[PROD_TIME_HRS])
),
[Labor Rate Salary])