Forum Discussion
ssspk
Helper III
2 years agoGetting 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...
- 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~