Getting error in executing the Measure in the DAX Studio?

[ssspk]

Hello Team,

I am getting the error in Dax studio while executing the Measure? The same works in PBI cloud Measue.

What could be the reason?

Thanks and Regards,

Siva

[xifeng_L · Accepted solution]

Hi @ssspk ,

In a DAX query, the query keyword "EVALUATE" must be declared first, and the DAX query must return the table at the end.

Therefore, you can rewrite your query like the following:

EVALUATE
{
    CALCULATE(
        DISTINCTCOUNT(data[user]),
        FILTER(
            data,
            (data[type] = 4 || data[type] = 6) && data[appid] > 0
        )
    )
}

Where "{}" acts as a table constructor syntax that can be used to create a table.

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[Jihwan_Kim]

Hi, 

I am not sure how your semantic model looks like, but in DAX Studio, please try to write DAX query something like below.

DEFINE
	MEASURE 'measuretablename'[UniqueUsersCount] = CALCULATE(
			DISTINCTCOUNT(data[user]),
			FILTER(
				data,
				(data[type] = 4 || data[type] = 6) && data[appid] > 0
			)
		)


EVALUATE
	SUMMARIZECOLUMNS(
		"UniqueUsersCount", 'measuretablename'[UniqueUsersCount]
	)