Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello friends, I'm having a hard time getting a solution to this problem, the problem is this: I have a manager, supervisor and salesperson, and I have a goal for this supervisor, with that the manager and the salesperson inherit that goal, until the moment is all right, the problem is the seller inherits the goal no problem, only the manager I wanted him not to reach the goal but the sum of his supervisors. Example:
Currently the manager is taking the average percentage of his supervisors, and I want him to do the reverse count and instead of taking the average of his supervisors, he does the reverse count taking the customers and the sum of the minimum goal and finding out how many percent this represents. I hope I managed to explain why I think I might have made it complicated.
Solved! Go to Solution.
@Anonymous , In case you want to change calculation at different levels , use in in scope
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
@Anonymous , In case you want to change calculation at different levels , use in in scope
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
User | Count |
---|---|
15 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
18 | |
13 | |
7 | |
5 |