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   ...
  • rsbin's avatar
    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,