topic Re: Getting error in executing the Measure in the DAX Studio? in DAX Commands and Tips

Getting error in executing the Measure in the DAX Studio?

ssspk — Wed, 15 May 2024 02:18:01 GMT

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

Re: Getting error in executing the Measure in the DAX Studio?

Jihwan_Kim — Wed, 15 May 2024 02:51:57 GMT

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

Re: Getting error in executing the Measure in the DAX Studio?

xifeng_L — Wed, 15 May 2024 03:36:18 GMT

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~