How to add or substract measures created in DAX and obtained from Source SQL?

[Anonymous]

Hi Experts,

I have some averages and Count I have from source file via the T-SQL and I have to create a few measures in the DAX 

Example in my case 

TotalCntSales (I have this from SQL and in Dax showing up as Summation symbol) 

Now I created Dax with Total sales of Sales_East, SalesWest 

As a validity check I wanted to create measure with Total Other Sales = TotalCntSales - (Measure_Sales_East + Measure_Sales_West)

But I can only see the Measures Created in Dax not what I have derived from Source. 

Workaround. I have created another measure in Dax for Total Sales but want to know if there is a smarter ways of doing it?

Thanks a lot.

[amitchandak]

@Anonymous , check the data type is the numeric type then you will see summarization sign 

also in measure, you need to take aggregated column (source will give column unless it analysis service or PBI dataset)

example 

sum(Table[TotalCntSales]) - (Measure_Sales_East + Measure_Sales_West)