I am trying to assign a cumulative % to each row of customer data based on descending values, so that I can then add another column to label each customer 'high value' (top 80% by value), 'medium value' (next 15%) or 'low value' (final 5%). I have tried to create this using DAX as follows:
(In case the above picture hasn't come through properly, the column formula looks like this:)
Running % = CALCULATE ( SUM ( 'Customer level'[Value %] ), FILTER ( ALL ( 'Customer level'[Index.1] , 'Customer level'[Index.1] <= MAX ( 'Customer level'[Index.1] ) ) ) )
I have added an Index column to give a rank but the above formula does not work.