Forum Discussion
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 1...
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" )
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" )
Thanks so much for helping.