cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mdx12_3
Frequent Visitor

Summing only 80% of sales out of total sales

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 

 

Image.JPG

3 REPLIES 3
lbendlin
Super User III
Super User III

"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
Frequent Visitor

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

 

Please help me out.

Jihwan_Kim
Community Champion
Community Champion

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])
 
Picture2.png
 
 
 

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


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.

Best regards, JiHwan Kim

Linkedin: https://www.linkedin.com/in/jihwankim1975/

Twitter: https://twitter.com/Jihwan_JHKIM

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors