Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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]
)
Solved! Go to 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])
@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])
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |