jamemoriaty
New Member
Hello everyone,
I got a difficult problem. I have 2 tables :


Bonus for new student enroll
Condition 1: Apply for Area code MiddeArea and NorthArea
Condition 2: % Act vs Target of Campus is greater than and equal 80%
Condition 3: # of New Student PD is greater than and equal 5

Bonus =Number of New Student PD x Bonus of group


Jame belong to Campus ADV which Area Code is MiddeArea and % Act vs Target 161% and # of New Student PD is 30. All of 3 conditions are satisfied.
Please help me to find the dax to calculate bonus of Jame include 3 conditions.
I got a difficult problem. I have 2 tables :


Bonus for new student enroll
Condition 1: Apply for Area code MiddeArea and NorthArea
Condition 2: % Act vs Target of Campus is greater than and equal 80%
Condition 3: # of New Student PD is greater than and equal 5

Bonus =Number of New Student PD x Bonus of group


Jame belong to Campus ADV which Area Code is MiddeArea and % Act vs Target 161% and # of New Student PD is 30. All of 3 conditions are satisfied.
Please help me to find the dax to calculate bonus of Jame include 3 conditions.