% number of grand total value

[Justas4478]

Hi, I have this data:

I need to create calculated column or DAX measure that shows only 60% of total Sales volume and wich SKU's are in that 60%.
Problem is I havent done this kind of calulation and dont know where to start or how to do it exactly.
Thanks

[ryan_mayu]

could you pls provide some sample data(not the tabel visual) and the expected output?

[amitchandak · Accepted solution]

@Justas4478 , I think you need something similar

Power BI Window: Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw