Row wise calculation

[PrasadPatil]

Hi Community..!!

please refer below sample data

Catergory    sales

A                     6

B                      4

C                      6

D                      4

Total                20     

I wanted to create a calculated column which includes logic like

=sale_value1(6) /total(20), sale_value2(4)/total(20), sale_value3(6)/total(20),sale_value4/total(20)

each sales row divide by grand total

Could anyone help me to do this calculation.

[rsbin · Accepted solution]

@PrasadPatil ,

Create a Measure to calculate Total Sales:

TotalSales = CALCULATE( SUM( Sales1[Sales] ),
                       ALL( Sales1 ))  // Where "Sales1" is the name of your table

Then create a Calculated Column:

Sales_Percent = DIVIDE( [Sales], [TotalSales], 0 )

Use the column tools menu to format as percent or decimal, whichever your preference.

Trust this is what you are looking for.

Regards,

[PrasadPatil]

Thanks for the Quick response @rsbin