New to DAX, super easy AVERAGE question!

[afaherty]

Hi All!

I am brand new to DAX, and am struggling majorly.  I feel like this question will be a peice of cake for most of you.  I have attached the testing data set I'm using to work on learning DAX.

Background:  It's dummy survey data.  There's 4 survey questions, scored on a Likert scale.  I have already recoded the Likert scale answers into codes (a scale of 1 to 4).  I have already unpivoted the data.  What I am trying to do is simply average the numerical responses for each survey question.  I came close, though I have since deleted the DAX out of rage (haha), so I can't recall how I did this but the numbers are correct...the decimals are just 2 decimal places off:

Below is the exact dummy data I am practicing with.  Can someone please help me figure this out?  Thank you so much!

ID	Question	Response
6	Understand the Diverse Needs of Students_Code	4
6	Plan for the Diverse Needs of Students_Code	3
6	Know the Required Content_Code	4
6	Effectively Teach Required Content_Code	3
9	Understand the Diverse Needs of Students_Code	4
9	Plan for the Diverse Needs of Students_Code	4
9	Know the Required Content_Code	4
9	Effectively Teach Required Content_Code	4
23	Understand the Diverse Needs of Students_Code	4
23	Plan for the Diverse Needs of Students_Code	4
23	Know the Required Content_Code	4
23	Effectively Teach Required Content_Code	4
25	Understand the Diverse Needs of Students_Code	4
25	Plan for the Diverse Needs of Students_Code	2
25	Know the Required Content_Code	4
25	Effectively Teach Required Content_Code	4
11	Understand the Diverse Needs of Students_Code	4
11	Plan for the Diverse Needs of Students_Code	4
11	Know the Required Content_Code	4
11	Effectively Teach Required Content_Code	4
28	Understand the Diverse Needs of Students_Code	4
28	Plan for the Diverse Needs of Students_Code	4
28	Know the Required Content_Code	4
28	Effectively Teach Required Content_Code	4
30	Understand the Diverse Needs of Students_Code	3
30	Plan for the Diverse Needs of Students_Code	3
30	Know the Required Content_Code	4
30	Effectively Teach Required Content_Code	4
12	Understand the Diverse Needs of Students_Code	4
12	Plan for the Diverse Needs of Students_Code	4
12	Know the Required Content_Code	2
12	Effectively Teach Required Content_Code	4
31	Understand the Diverse Needs of Students_Code	4
31	Plan for the Diverse Needs of Students_Code	4
31	Know the Required Content_Code	4
31	Effectively Teach Required Content_Code	2
10	Understand the Diverse Needs of Students_Code	4
10	Plan for the Diverse Needs of Students_Code	4
10	Know the Required Content_Code	4
10	Effectively Teach Required Content_Code	4
15	Understand the Diverse Needs of Students_Code	4
15	Know the Required Content_Code	4
15	Effectively Teach Required Content_Code	4
17	Understand the Diverse Needs of Students_Code	4
17	Plan for the Diverse Needs of Students_Code	4
17	Know the Required Content_Code	2
17	Effectively Teach Required Content_Code	4
24	Understand the Diverse Needs of Students_Code	4
24	Plan for the Diverse Needs of Students_Code	4
24	Know the Required Content_Code	4
24	Effectively Teach Required Content_Code	2
29	Understand the Diverse Needs of Students_Code	4
29	Plan for the Diverse Needs of Students_Code	4
29	Know the Required Content_Code	4
29	Effectively Teach Required Content_Code	4
13	Understand the Diverse Needs of Students_Code	4
13	Plan for the Diverse Needs of Students_Code	4
13	Know the Required Content_Code	4
13	Effectively Teach Required Content_Code	4
7	Understand the Diverse Needs of Students_Code	4
7	Plan for the Diverse Needs of Students_Code	3
7	Know the Required Content_Code	4
7	Effectively Teach Required Content_Code	4
16	Understand the Diverse Needs of Students_Code	3
16	Plan for the Diverse Needs of Students_Code	3
26	Understand the Diverse Needs of Students_Code	3
26	Plan for the Diverse Needs of Students_Code	3
26	Know the Required Content_Code	3
26	Effectively Teach Required Content_Code	3
27	Understand the Diverse Needs of Students_Code	4
27	Plan for the Diverse Needs of Students_Code	4
27	Know the Required Content_Code	4
27	Effectively Teach Required Content_Code	4
18	Understand the Diverse Needs of Students_Code	4
18	Plan for the Diverse Needs of Students_Code	4
18	Know the Required Content_Code	4
18	Effectively Teach Required Content_Code	4
19	Plan for the Diverse Needs of Students_Code	4
19	Know the Required Content_Code	4
19	Effectively Teach Required Content_Code	2
21	Understand the Diverse Needs of Students_Code	4
21	Plan for the Diverse Needs of Students_Code	2
21	Know the Required Content_Code	2
21	Effectively Teach Required Content_Code	4
14	Understand the Diverse Needs of Students_Code	4
14	Plan for the Diverse Needs of Students_Code	3
14	Know the Required Content_Code	4
14	Effectively Teach Required Content_Code	4
20	Understand the Diverse Needs of Students_Code	4
20	Plan for the Diverse Needs of Students_Code	4
20	Know the Required Content_Code	4
20	Effectively Teach Required Content_Code	4

[PaulOlding · Accepted solution]

Unless I'm reading the question incorrectly it should be just:

ResponseAVG = AVERAGE('Table'[Response])

You can control the decimal places and other formatting in the Measure Tools ribbon

[afaherty]

Oh wow, I figured out the issue!  You are correct with the DAX, but the error I was encountering with AVERAGE was that my recoded "Response" column was in as a text field, when it should've been formatted as whole number.  As soon as I fixed that, all was well!  Thank you!