Pareto Curve in Power BI/DAX - % customers vs % sales
Hello dear community members, I've been trying to solve this for a while, but not luck so far. I need to have a 'Sales Concentration Curve', that is a Pareto curve basically, but instead of having CUSTOMERS on the X-Axis, having a percentage (i.e: X% of customers give Y % of volume). I got this for now: It only works if I add the Bar values (that is sales value) which is basically Sum of Sales Value. and creating the following measure which draws the curve using the below code: Cust volume Concentration = VAR total_SalesVol = CALCULATE(SUM(oos_master_customer[Sales LY]),ALLSELECTED(oos_master_customer)) VAR current_SalesVol = SUM(oos_master_customer[Sales LY]) VAR summarized_Table = SUMMARIZE( ALLSELECTED(oos_master_customer), oos_master_customer[customer_unique_code], "volume",SUM(oos_master_customer[Sales LY]) ) VAR CumulativeSum = SUMX( FILTER(summarized_Table,[volume] >= current_SalesVol), [volume] ) RETURN DIVIDE(CumulativeSum,total_SalesVol) The curve is redrawn appropriatly when applying filters on the graph. So all works perfectly. What I am missing: is to have on the X-axis, instead of the customer (11k of them), just percentage 0-100% based on their ranking of largest to smallest. My model has: 1 Transaction (facts) table for sales linked to 1 Customer (Dim) table linked to 1 Product (Dim) table (to the facts table obviously) Thanks a lot I spent too many hours trying to figur that out - your help is very much appreciated. thanks a lot
