cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mdx12_3
Regular 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?

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

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Kudoed Authors