• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Please help me find the dax for calculating bonus staff

jamemoriaty

New Member
Hello everyone,

I got a difficult problem. I have 2 tables :

82848

82849

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

82850

Bonus =Number of New Student PD x Bonus of group

82851

82852

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.
 
Back
Top