Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Single value for a column cannot be determined

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!

Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

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

7 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi Anonymous 
    You need to wrap Index with SELECTEDVALUE 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        tamerj1
        Community Champion
        4 years ago

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