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   ...
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,

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,

PrasadPatil's avatar
PrasadPatil
Regular Visitor
3 years ago

Thanks for the Quick response rsbin