Basic DAX Issue

[Clockwise]

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  basic

Test_Measure = sum('Table 1'[AQuality])

then I hit the Run and at the bottom I see Results window below it  says "Resolve the error to see the results." and it does not show me where is the error. Even something like

Test = 2+3 

fails with similar error. What am I missing? 

[Kedar_Pande]

@Clockwise 

Query View is for EVALUATE queries only:

EVALUATE
ROW("Test", 2+3)

If this answer helped, please click 👍 or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande

[cengizhanarslan · Accepted solution]

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.

[Mauro89]

Hi @Clockwise,

check out this, maybe it helps you with kick start: 
DAX Query View - Power BI | Microsoft Learn

And, dont forget the "Evaluate" in the beginning 😉

Best regards!

PS: If you find this post helpful consider leaving kudos or mark it as solution

[Clockwise]

Thanks for the reply. Actually I was reading that page too, so I changed the formulae to something like this. 

to 

Define

measure 'Table1'[Measure_test] = sum('Table1'[AQuality])

Evaluate 

SUMMARIZECOLUMNS(

        "Measure_test", [Measure_test]

    )

it seems something is working but not fully now, so got this error now. 

A single value for column 'AQuality' in table 'Table1' cannot be determined. This can happen when a measure or function formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

I guess the sum was not the right choice, 

[RV0251]

Hi, You’re not missing anything obvious this is just how DAX Query View works, and it’s a bit confusing at first. The key thing is that DAX Query View does NOT run measures. It only runs DAX queries. So when you write something like: Test_Measure = SUM ( 'Table 1'[AQuality] ) or even: 2 + 3 it will always fail there, even though those are perfectly valid DAX expressions. In DAX Query View, everything has to be a query, and queries must start with EVALUATE. For example, this will work: EVALUATE ROW ( "Result", 2 + 3 ) Or for your column sum: EVALUATE ROW ( "Total AQuality", SUM ( 'Table 1'[AQuality] ) ) You should see the result in the Results pane after running it. If your goal is just to create a measure, you don’t need DAX Query View at all. Just go to New measure in Report or Model view and paste: Test_Measure = SUM ( 'Table 1'[AQuality] ) Think of DAX Query View more like running a SQL SELECT statement it’s for testing queries, not defining measures. This trips up a lot of people at first, so you’re definitely not alone

[Clockwise]

This is a great way to explain! Thanks!