Summing only 80% of sales out of total sales

[Mdx12_3]

Dear All,

I have attached an pbix file link  of 100 Rows and wanted some output in power bi in tabular form only.

Sample data includes Order wise product sales and qty sold.

• I want sales column can only give 80% of total sales i.e. 7013.72, instead of 100% sales i.e. 8767.15.
• Want to keep only those rows and products that give 80% sales, rest rows wanted to remove.
•  Also, Ranking (S.No.) should be correct while summing only 80% sales.

Kindly, help me out. Not able to figure out the solution. @lbendlin , @Jihwan_Kim, @dm-p 

[lbendlin]

"Want to keep only those column and products that give 80% sales, rest columns wanted to remove."

Did you mean rows instead of columns?

[Mdx12_3]

Yes, wanted to remove rest of 20% sales rows.

Please help me out.

[Jihwan_Kim]

Hi, @Mdx12_3 

I am not sure if I understood your question correctly, but please check the below picture and the link down below.

I only changed the sales measure like below.

Sales = SUMX(Sheet1, Sheet1[Total price per product] * Sheet1[Qty sold])

https://www.dropbox.com/s/rr8t1cp7nh8uchk/Sample%20file.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM