Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear all
Below is my current measure
Solved! Go to Solution.
Hi @vjnvinod ,
Please try this formula.
Preboarding Pipeline1 =
COUNTA('Onboarding Report'[Employee Name])+
CALCULATE(
COUNTA('Experienced Hired Report'[Location City]),
'Experienced Hired Report'[Status]="Under offer"
)+
CALCULATE(
COUNTA('Campus Hire Report'[Location City]),
'Campus Hire Report'[Status]="Under offer"
)-
CALCULATE(
COUNTA('Onboarding Report'[Employee Name]),
FILTER(
ALL('Onboarding Report'),
CONTAINSSTRING(
'Onboarding Report'[Employee Category],
"Internal Transfer"
) = TRUE()
)
)
CONTAINSSTRING function (DAX) - DAX | Microsoft Docs
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@vjnvinod , search can do ?
example
search("Internal Transfer",'Onboarding Report'[Employee Category],,0)>0
I think i manage to fingure it out
Hi @vjnvinod ,
Please try this formula.
Preboarding Pipeline1 =
COUNTA('Onboarding Report'[Employee Name])+
CALCULATE(
COUNTA('Experienced Hired Report'[Location City]),
'Experienced Hired Report'[Status]="Under offer"
)+
CALCULATE(
COUNTA('Campus Hire Report'[Location City]),
'Campus Hire Report'[Status]="Under offer"
)-
CALCULATE(
COUNTA('Onboarding Report'[Employee Name]),
FILTER(
ALL('Onboarding Report'),
CONTAINSSTRING(
'Onboarding Report'[Employee Category],
"Internal Transfer"
) = TRUE()
)
)
CONTAINSSTRING function (DAX) - DAX | Microsoft Docs
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.