Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I want to embed calculation into a DAX IF statement. This shouldn't be hard. On each line of a report (one employee per line):
If an employee is salaried, I want to use the PayRate as the Wage.
If the employee is hourly, I want to multiply the PayRate by the Hours to get Wage.
But I'm getting an error:
The command is:
Solved! Go to Solution.
Hi @Anonymous ,
Please try this:-
Measure =
IF (
MAX ( CompFixedEmpls[Plan] ) = "Salary",
SELECTEDVALUE ( CompFixedEmpls[PayRate] ),
SELECTEDVALUE ( CompFixedEmpls[PayRate] )
* SELECTEDVALUE ( PositionsV2[AnnualRegularHours] )
)
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @Anonymous ,
Please try this:-
Measure =
IF (
MAX ( CompFixedEmpls[Plan] ) = "Salary",
SELECTEDVALUE ( CompFixedEmpls[PayRate] ),
SELECTEDVALUE ( CompFixedEmpls[PayRate] )
* SELECTEDVALUE ( PositionsV2[AnnualRegularHours] )
)
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
14 | |
10 | |
7 |