Forum Discussion
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])
2 Replies
- rathimdFrequent Visitor
- amitchandakSuper User
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])