Column or formula

[sdhn]

Hi All,

I am using Power Bi desktop to develope DBs.

I have a source table similar to below:

Fruits	Sale	Total Sales
Apple	10	200
Mango	20	500
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 

[FrankAT · Accepted solution]

Hi @sdhn ,

with a calculated column:

With a measure for a matrix:

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

[v-easonf-msft · Accepted solution]

Hi, @sdhn 

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

divide-function-dax 

Best Regards,
Community Support Team _ Eason

[FrankAT · Accepted solution]

Hi @sdhn ,

with a calculated column:

With a measure for a matrix:

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