Forum Discussion

sdhn's avatar
sdhn
Responsive Resident
5 years ago
Solved

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 

Need Help
  • FrankAT's avatar
    FrankAT
    5 years ago

    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)

2 Replies

  • FrankAT's avatar
    FrankAT
    Community Champion
    5 years ago

    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)