The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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]
)
@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
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.
User | Count |
---|---|
79 | |
74 | |
42 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |