<div>
@Author - a feedback is appreciated. :)
</div>


<div>
Question abandoned.<br />
Provided solution.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
i want to put in a variable th sum of sales.<br />
example:<br />
<br />
var myvariable = <br />
EVALUATE<br />
SUMMARIZE('Internet Sales'<br />
,&quot;Internet Sales&quot;,'Internet Sales'[Internet Total Sales]) <br />
<br />
i am just getting error from SQL server management studio. <br />
Thanks for your help
</div>
</div>


Hi,

i want to put in a variable th sum of sales.
example:

var myvariable = 
EVALUATE
SUMMARIZE('Internet Sales'
,"Internet Sales",'Internet Sales'[Internet Total Sales]) 

i am just getting error from SQL server management studio. 
Thanks for your help

use variable with DAX in SSMS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.

Sales

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.