Forum Discussion

ssspk's avatar
ssspk
Icon for Helper III rankHelper III
2 years ago
Solved

Getting error in executing the Measure in the DAX Studio?

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 Reg...
Help
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    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's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

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]
	)