Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ydundar
Frequent Visitor

SELECTEDVALUE function doesn't recognized

Hi to all,

 

I am trying to create a new measure by using a selected value from a slicer. First i created a demo by deploying the model to local sql server which has supported compatibility level 1200 and can use SELECTEDVALUE function in power bi dax query. But after deploy the model to sql server in the server which has supported compatibility level 1103 and get data in live connection mode couldn't see SELECTEDVALUE. So is it there a way to fix this situation? Thanks for any help.

1 ACCEPTED SOLUTION
Stachu
Community Champion
Community Champion

you can use the IF + HASONEVALUE combination, as explained here
https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/

IF ( HASONEVALUE ( Table[column] ), VALUES ( Table[column] ), "default value" )

 



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

2 REPLIES 2
Stachu
Community Champion
Community Champion

you can use the IF + HASONEVALUE combination, as explained here
https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/

IF ( HASONEVALUE ( Table[column] ), VALUES ( Table[column] ), "default value" )

 



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Thanks so much for helping. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors