Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone, I have a report to calculate bonus of staff as :
Bonus for new student enrollment
Bonus =Number of New Student PD x Bonus of group
-Apply for condition type NEW ENROLLMENT :
1. Area code : HCMC, SouthArea
2.% Act vs Target of Campus is greater than and equal 80%
3.# of New Student PD is greater than and equal 5
Another conditions apply for type NEW ENROLLMENT
1. Campus code : NewArea, VT Area
2.% Act vs Target of Campus is greater than and equal 75%
3.# of New Student PD is greater than and equal 3
Dax for calculating this report:
------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------
I use this dax to calculate bonus for staff. But I have a problem , the condition [% Act vs Target of Campus] is greater than and equal 80% is applied for a whole of campus not for everyone belong of campus.
Example :
The dax just calculate for staff who is [% Act vs Target] 107% and not calculate for 2 staffs . I need the dax apply for whole campus which [% Act vs Target] is greater than 80% (as Campus code ADV is 161%) , not for [% Act vs Target] of staff is greater than 80%
Similarly, the condition [% Act vs Target of Campus] is greater than and equal 75% is applied for a whole of campus.
I post plib in this link : https://app.powerbi.com/groups/me/reports/ac39c2eb-d6d9-46d6-9f87-3fe72272633e?ctid=d1005fc5-bff9-42...
Can everyone help me to fix that dax ?
Hi @sakuragihana,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Notice: please exclude sensitive data before sharing.
Regards,
Xiaoxin Sheng
Hi @v-shex-msft ,
Please use this link : https://app.powerbi.com/groups/me/reports/ac39c2eb-d6d9-46d6-9f87-3fe72272633e?ctid=d1005fc5-bff9-42...
Dax in sheet Bonus Sale Performance . Although, the dax of bonus_new_revenue and the dax of bonus_re_enroll is the same , I need the dax apply for all of staff who satisfy the conditions . Can you help me to fix that dax ?
Hi @sakuragihana,
In fact, the shared report link does not help, I can't view these shared contents.
Perhaps you can create some dummy data with similar structure and Dax expressions in a sample pbix file and share here. They will help us test to coding formula and troubleshoot on your scenario.
Regards,
Xiaoxin Sheng
Hi @v-shex-msft ,
Can you give me your email ? So I will share a report link for you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |