Single value for a column cannot be determined

[Anonymous]

Hi, 

I am trying to create a measure so that I can calculate a rolling 4 interval average (I only have interval # and no date). However when trying to use an index to order the intervals, I receive this error:

My data table looks like the following:

Thank you for any help!

[tamerj1]

Hi @Anonymous 
You need to wrap Index with SELECTEDVALUE 

[Anonymous]

I am unfamiliar with SELECTEDVALUE and am not sure what to enter for the alternate result in the function. Could you provide more detail?

[tamerj1]

@Anonymous 
Like this 
VAR MyIndex = SELECTEDVALUE ( 'Rolling Table'[Index] )

[Anonymous]

Thank you. I tried that, however instead of calculating the average over the number of specified intervals the measure just returns the total for each. See below:

[tamerj1 · Accepted solution]

@Anonymous 
Inside FILTER, instead of 'Rolling Table', use ALL ( 'Rolling Table' ),

[tamerj1]

@Anonymous 

Would you please copy/paste the code here so I can edit it

[Anonymous]

Thank you so much! Posting final DAX expression should anybody need to reference it:

Moving Average =

VAR MyIndex = selectedvalue('Rolling Table'[Index])

VAR myResult =

AVERAGEX(

FILTER(

ALL('Rolling Table'),

'Rolling Table'[Index] > MyIndex-4 &&

'Rolling Table'[Index] <= MyIndex

),'Rolling Table'[EDD]

)

RETURN FIXED(myResult,2)