Forum Discussion

PrasadPatil's avatar
PrasadPatil
Regular Visitor
3 years ago
Solved

Row wise calculation

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.

Need Help
Show and Tell
  • rsbin's avatar
    rsbin
    3 years ago

    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,

2 Replies

  • rsbin's avatar
    rsbin
    Community Champion
    3 years ago

    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,