Calculated Columns With Multiple Conditions

[AlanP514]

Hai All, I am a dax learner, Asking your help to solve this problem

In the above Dax, I want to add one more condition, ie, in the activity, the log table initiative type should be "Sprint"
That means I want to add 
Filter(Activity Log, Activity Log[Intiative type]="Sprint")
How to add this Condition to the above particular Dax

[truptis · Accepted solution]

Hi @AlanP514 ,
Please try this:
Result = calculate(if(related('talent 1 database'[user email]) = 'certification log[work email],"Yes","no"), filter(Activity Log, 'Activity Log'[Initiative type]="Sprint"))

@AlanP514 -If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudo 👍
Thanks!
Regards,
TruptiS