Need help a dax for calculating bonus

[Simple_one]

Hello everyone,

 I have a table Package Course :

And a table Bonus :

 I have a table :

 I have to calculate bonus for people as :

Example : 

Bao Quoc Thang  :

Bonus = (2 * 150000) + (2*300000)+(8*400000)= 4900000

This is a link for power BI file : https://drive.google.com/file/d/1TQUGX8Ma0MUN6ZdAqfSB3Ml3BTF_aUKh/view?usp=drive_link 

 Please someone help me for this dax.

[cosm · Accepted solution]

Hi @Simple_one .

Try this approach:

1) Add the following measure:

Bonus (#new student * Bonus pr student) =
 // Multiply the bonus and the # of New student, then take the sum
    SUMX( Bonus, Bonus[Bonus]  *
        Data[# of New Student]
)

The measure above use SUMX to multiply the two columns from two different tables.

2) Add the measure to a table/matrix or similar to obtain the bonus for each user name.

See snip below

Hope this helps.

If the answer solved your problem, consider accepting it as a solution.

[Ahmedx]

1) in the DATA table create the following column

2) and then calculate like this

[cosm · Accepted solution]

Hi @Simple_one .

Try this approach:

1) Add the following measure:

Bonus (#new student * Bonus pr student) =
 // Multiply the bonus and the # of New student, then take the sum
    SUMX( Bonus, Bonus[Bonus]  *
        Data[# of New Student]
)

The measure above use SUMX to multiply the two columns from two different tables.

2) Add the measure to a table/matrix or similar to obtain the bonus for each user name.

See snip below

Hope this helps.

If the answer solved your problem, consider accepting it as a solution.

[Simple_one · Accepted solution]

Hi @cosm ,

Thank you a lot