Forum Discussion
Clockwise
Helper I
Helper IBasic DAX Issue
I have created measures before but have not used the DAX Query View, now tried to do basic things but I am failing in anything, I understand I am new to this but sounds I am missing something basi...
You’re writing measure definitions in DAX Query View and pressing Run. But DAX Query View does not accept measure definitions.
Example 1: simple calculation
EVALUATE ROW ( "Result", 2 + 3 )Example 2: test your aggregation
EVALUATE SUMMARIZE ( 'Table 1', "Total AQuality", SUM ( 'Table 1'[AQuality] ) )Now press Run → results will appear.
DAX Query View runs queries (EVALUATE …), not measure definitions. Create measures in the measure editor, or wrap logic in EVALUATE when using Query View.
cengizhanarslan
Super User
Super UserYou’re writing measure definitions in DAX Query View and pressing Run. But DAX Query View does not accept measure definitions.
Example 1: simple calculation
EVALUATE
ROW ( "Result", 2 + 3 )
Example 2: test your aggregation
EVALUATE
SUMMARIZE (
'Table 1',
"Total AQuality", SUM ( 'Table 1'[AQuality] )
)Now press Run → results will appear.
DAX Query View runs queries (EVALUATE …), not measure definitions. Create measures in the measure editor, or wrap logic in EVALUATE when using Query View.