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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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