Net sales vs Total sales

[Alex_Hasan]

If I want to write a dax measure for Total sales, what would it be? 

1. Is it the summation of net sales? or

2. should I subtract Distribution and warehousing cost from Net sales? 

[amitchandak]

@Alex_Hasan, Not very clear

If net sales is column

A measure

Total Sales = Sum(Table[Net Sales])

should I subtract Distribution and warehousing cost from Net sales?

What is the requirement ?

Total Sales = Sum(Table[Net Sales]) -Sum(Table[Distribution Cost])  -Sum(Table[warehousing Cost]) 

[Alex_Hasan]

Oh sorry, there was a mistake in the question. Now I am going to say it clearly. 

When we want to calculate total sales, we add up all the cost related to the sales and subtract discount from it.

In the Net Sales column, the discount has been already minus. But there are Cost of Goods Sold, Distribution cost and Warehousing Cost columns that come into the play. so, what will be the Actual total sales? I am stuck here. 

[amitchandak · Accepted solution]

@Alex_Hasan , They are negative, you can add up

Total Sales = Sum(Table[Net Sales]) +Sum(Table[Distribution Cost]) +Sum(Table[warehousing Cost])

[Alex_Hasan]

Thank you so much.