Total sum of a column

[pro_x]

Hi,

How do i get the total Sales for each row. I used this measure 

Total Sales = CALCULATE([Sales],ALL('Table'))

and it gives me the total of one row (Sales) and it puts it across all rows

I want to get the total of a column per row per month

[AntrikshSharma]

Try something like this:

Column 2 =
VAR SalesMonth =
    MONTH ( Sales[Order Date] )
VAR Result =
    CALCULATE (
        [Total Sales],
        FILTER ( Dates, Dates[Month Number] = SalesMonth ),
        ALL ( Sales )
    )
RETURN
    Result

The below image is from my sales table which has one to many relationship with dates. you can see that all the rows that are for same month have the same value.

the amount in the above 2 pictures can be verified by the below one. by using a measure like 

Total Sales = SUMX ( Sales, Sales[Quantity] * Sales[Net Price] )

[mwaltercpa]

I'd need more to understand what you mean by total sales per row. It appears you already have a sales column on the left of your measure. I can tell you that using ALL() is going to remove the filters, and that is why you are getting the grand total on every row. ALL is ignoring the filters on that table, and for each cell is repeating the act of summing all the dollars available in the column.