cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sdhn
Post Patron
Post Patron

Column or formula

Hi All,

 

I am using Power Bi desktop to develope DBs.

 

I have a source table similar to below:

 

FruitsSaleTotal Sales
Apple10200
Mango20500

Pomegranate

 

25 600

 

I need to write column or messaure to find result sale/total sales for each fruit.

 

For Apple :   10/200 * 100 = 5 %

 

Any help will be appreciated 

2 ACCEPTED SOLUTIONS
FrankAT
Community Champion
Community Champion

Hi @sdhn ,

with a calculated column:

 

23-07-_2021_00-30-45.png

 

With a measure for a matrix:

 

23-07-_2021_00-30-29.png

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

View solution in original post

v-easonf-msft
Community Support
Community Support

Hi, @sdhn 

If you are not familiar with measure, you can start with “quick measure” to familiarize yourself with some commonly used functions.

1.png

2.png

divide-function-dax 

 

Best Regards,
Community Support Team _ Eason

View solution in original post

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Hi, @sdhn 

If you are not familiar with measure, you can start with “quick measure” to familiarize yourself with some commonly used functions.

1.png

2.png

divide-function-dax 

 

Best Regards,
Community Support Team _ Eason

View solution in original post

FrankAT
Community Champion
Community Champion

Hi @sdhn ,

with a calculated column:

 

23-07-_2021_00-30-45.png

 

With a measure for a matrix:

 

23-07-_2021_00-30-29.png

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

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

Top Solution Authors