Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Super User

"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
Super User
Super User

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 accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors