Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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:
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:
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
12 | |
9 | |
9 | |
9 |
User | Count |
---|---|
21 | |
14 | |
14 | |
13 | |
13 |