Forum Discussion

Clockwise's avatar
Clockwise
Helper I
7 months ago
Solved

Basic 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...
  • cengizhanarslan's avatar
    cengizhanarslan
    7 months ago

    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.