Price percentile weighted by volume

[Anonymous]

Hey guys! 

I am new to Power BI and I looked through a lot of posts here but could not find what I need. So I would like to explain what I am trying to analyse. I have customer sales data with volumes and prices. I would like to find the 10th percentile of the price, but weighted by the volume. So basically manually it would look like that I would sort the customers in an ascending order by average price and then in the next column I would have the cummulative volume. When we reach the 1/10 value of the total volume in the cummulative volume, we check what price we have there and this is the price I need. Maybe I am overcomplicating things, it seems like an easy task to do. I can do this in excel, but would be nice to have it in power BI because I would like to filter by product types, etc. 

Thank you in advance.
Gergely

[v-chuncz-msft]

@Anonymous ,

You may try Quick measure Running total and TOPN Function.

https://community.powerbi.com/t5/Desktop/Card-Help/td-p/514770

[Anonymous]

Thank you for your answer. I was not able to do it in Power BI. But I realized that I wasted way too much on this simple task and just simply did it with the combination of a pivot table and some calculations next to it.