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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.