Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

SELECTEDVALUE() function not recognized

I'm trying to create a measure that grabs last year's sales so that I can compare them to this year's sales.   It is saying that the SELECTEDVALUE() is not recognized. "The report measure FactSale...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous instead of selectedvalue , replace it with min or max function.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Get Data -> Analysis Services -> type in database

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous seems like you are using direct query to connect to Analysis service, read this post to understand what DAX functions are allow/optimized when direct query mode is used.