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 Regards,

Siva

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~

2 Replies

  • xifeng_L's avatar
    xifeng_L
    Icon for Super User rankSuper User
    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]
	)