Forum Discussion

cgrisham's avatar
cgrisham
Frequent Visitor
8 years ago

SELECTEDVALUE not a valid function

I've read that going back to July there was an issue with Intellisense not picking up SELECTDVALUE and the issue was said to be fixed "soon". 3 Months later looks like its not only not being picked...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi cgrisham,

 

Based on my test, SELECTEDVALUE is not a supported function in DirectQuery mode. Referring to it in import mode, above error won't prompt.

 

Direct Query

 

Import

 

Reference: DAX functions in DirectQuery mode

 

Best regards,
Yuliana Gu

cgrisham's avatar
cgrisham
Frequent Visitor
8 years ago

v-yulgu-msft thanks for the resposne as well as the test you performed and link your provided. 

I'm reading that article though as all functions are supported, just not all are optimized. Great to know it works in import, but still seems like it may be a bug in Direct Query? Unless PBI only supports optimized DAX functions in DIrectQuery mode. 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi cgrisham,

     

    You could submit this idea that make SELECTEDVALUE optimized in DirectQuery mode. Your feedback is valuable to improve the level of our products.

     

    Regards,
    Yuliana Gu