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

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

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