Reply
adnanarain
Helper V
Helper V
Partially syndicated - Outbound

Measure Performance Issue

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
amitchandak
Super User
Super User

Syndicated - Outbound

@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

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

Syndicated - Outbound

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.

avatar user

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.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)