Forum Discussion

rathimd's avatar
rathimd
Frequent Visitor
3 years ago
Solved

Calculate column returning multiple values in if condition

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 , try like

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