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 Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors