Need help for applying complicated condition for dax

[Simple_one]

Hello everyone,

I have 2 table below :

Table 1 :

Table 2 :

Table 2 is explained below :

Condition for calculating bonus for Group 1 -> 7:

1.% New Std PD and Re open vs Target >= 90%

2.If % New Student PD vs New Enrol PD Target < 80% , the bonus will be lowered by 1 level ( Note : If the New Student PD vs New Enrol PD Target is smaller than 80% and the bonus at level 1, the bonus will not be received)

3.If % New Student PD vs New Enrol PD Target < 80% and Campus code is Group 6 or Group 7, the bonus will be lowered by 1 level (Note : If the New Student PD vs New Enrol PD Target is smaller than 80% and the bonus at level 1, the bonus will be minus 500,000)

Condition for calculating bonus for Group 8:

1.% New Std PD and Re open vs Target >= 80%

2.If % New Student PD vs New Enrol PD Target < 65% , the bonus will be lowered by 1 level ( Note : If the New Student PD vs New Enrol PD Target is smaller than 65% and the bonus at level 1, the bonus will be minus 500,000)

Example 1:

Campus NCT has :

% New Std PD and Re open vs Target = 103%

% New Student PD vs New Enrol PD Target = 75%

Bonus of Campus NCT (belong Group 2 ) is level 2: 9,000,000 ( with % New Std PD and Re open vs Target =103%) . However, because % New Student PD vsa New Enrol PD Target is smaller than 80% , so the bonus will be lowered by 1 level . The bonus will be level 1 =7,000,000

Example 2:

Campus BD-BCM:

% New Std PD and Re open vs Target = 98%

% New Student PD vs New Enrol PD Target = 50%

Bonus of Campus BD-BCM (belong Group 6) is level 2 : 3,000,000 ( with % New Std PD and Re open vs Target =98%) . However, because % New Student PD vsa New Enrol PD Target is smaller than 80% , so the bonus will be : 2,500,000

Example 3:

Campus HN-GP:

% New Std PD and Re open vs Target = 86%

% New Student PD vs New Enrol PD Target = 48%

Bonus of Campus HNI-CT (belong Group 8 is level 1 : 2,000,000 ( with % New Std PD and Re open vs Target =86%) . However, because % New Student PD vsa New Enrol PD Target is smaller than 65% , so the bonus will be : 1,500,000

I have a power BI in this link : https://drive.google.com/file/d/1KpeOK1IfKS0hE_6FJy5rv0ZHByDIDmd5/view?usp=drive_link 

This condition is so complicated for me. Please help me for making this dax ! Thank you

[Alef_Ricardo_]

Hello Simple_one!

I see that you have a complex DAX problem that you need help with. From what I understand, you have two tables and you need to calculate the bonus for different groups based on certain conditions. It seems like the conditions for calculating the bonus are different for each group and depend on various factors such as the percentage of new students, the campus code, and the target values.

Based on the information you provided, it seems like you could use a combination of `IF` and `SWITCH` statements to calculate the bonus for each group. You could use `IF` statements to check if the conditions for each group are met and then use a `SWITCH` statement to determine the bonus level based on the group and the conditions.

However, without more information about your data model and the exact calculations you need to perform, it's difficult for me to provide a more specific solution. If you could provide more details about your data model and the calculations you need to perform, I would be happy to help you further.

In the meantime, you might find it helpful to check out some tutorials on using DAX in Power BI. There are many resources available online that can help you learn more about DAX and how to use it effectively in Power BI. For example, here are some video tutorials that might be helpful:

[Simple_one]

Hi @Alef_Ricardo_ ,

Data model I made this in the power BI file in the link .

I need the output of calculation as :

Thank you so much if you can help me !

[Simple_one]

Hello everyone,

Please someone help me !