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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Companyuser101
Helper II
Helper II

Performance Improve for Measure

Hello together, 

 

I need to improve the performance for my measure. 

 

So in my data we have 6 different manager. All the manager have different costumers. 

Every costumer has goals to achieve. When they achieve the goals, we pay them a bonus. 

The goals are for example retails.

 

So all the manager have the sum of the costumers goals. For example

costumer 1: achieved 3 from 6 retails --> 50%

costumer 2: 4 from 10 --> 25%

costumer 3: 2 from 2 --> 100%

Then the manager has then achieved: 9 from 18 --> 50% 

But when we take the average from the three costumers we have: 41,67% 

And I want the average, but Power BI gives me the 50%. 

 

So when I calculated the bonus I then made a sum of every bonus from the costumer and got this:

 

Companyuser101_0-1675255770232.png

 

so for every bonus I filtered after the costumer, which gives me a long measure and takes a lot of time to process.

When I do this I get the right bonus. 

 

I tried to make it slimer: 

Companyuser101_1-1675255835808.png

Here I filtered after the manager, but It does not work because I get the 50% (from above) 

 

How Can I change the measure to improve performance?

 

Thank you!

 

0 REPLIES 0

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.