Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Measure Performance Issue
06-01-2023
02:53 AM
Please see below measure, i am trying to calculate number of customers with 80% sales. I am getting correct result but measure responding very slow almost takes 40 seconds to refresh 3 month data. I am using calculated customer table as i dont have the separate customer table in model.
Customer 80% =
VAR totalsales = [Sales]
VAR vtable =
SUMMARIZE(
Customer,
Customer[CustomerN],
"vRanking",RANKX(ALLSELECTED(Customer),[Sales],,DESC),
"vSales",[Sales])
VAR vtable2 = ADDCOLUMNS(vtable,
"v2CumSales",SUMX(FILTER(vtable,EARLIER([vRanking])>=[vRanking]),[vSales]))
RETURN
Countx(
FILTER(vtable2,[v2CumSales]<=totalsales*0.80),
[vSales]
)
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-01-2023
09:28 AM

@adnanarain , refer if window function and measure can help
Power BI Window: Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-01-2023
12:20 PM

I treid your soultion but it is also slow and giving error "Visual has Exceed available resources" , I have 29K customers so i want to calculate no of customers who contribute 80% of sales, Sales, cost, profit and profit % for the same. Actually i want the ABC analysis.

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
05-26-2025 09:10 AM | |||
yesterday | |||
07-09-2025 01:23 PM | |||
12-11-2024 07:30 PM | |||
01-28-2025 03:31 PM |
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
73 | |
69 | |
36 | |
25 | |
22 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
96 | |
94 | |
53 | |
45 | |
39 |