Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

help with percentage metric

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:Capturar.PNG

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.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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/

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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/

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors