Dax Studio Incorrect Syntax

[Anonymous]

New to using Dax Studio and cant figure out why I am getting incorrect syntax and in the result pane it appears to be adding additional ( into the equation. Am I just overlooking something very simple here ? 

[BA_Pete]

Hi @Anonymous ,

Firstly, in DAXStudio, you need to start every query with EVALUATE.

Secondly, to materialise a scalar value (from a measure etc.) rather than a table, ou need to use the ROW() function.

Try this and see how you get on:

EVALUATE
ROW(
    "Sales Amount",
    SUMX(
        'Internet Sales',
        'Internet Sales'[Order Quantity] * 'Internet Sales'[Sales Amount]
    )
)

*EDIT* Or you could do what @johnt75 said as well, lol. 😄

Pete

[johnt75]

In DAX Studio you need to use DEFINE and EVALUATE,

DEFINE
    MEASURE 'Internet Sales'[Sales Amount] =
        SUMX (
            'Internet Sales',
            'Internet Sales'[Sales quantity] * 'Internet Sales'[Sales amount]
        )

EVALUATE
{ [Sales amount] }

Another couple of points worth noting. When you define a measure you need to use a table name as well as the measure name.

When you do an EVALUATE it requires a table expression, so if you simply want to evaluate a measure you need to wrap it in the table constructor { }