Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone!
I'm trying to write DAX code to return a measure which includes a SELECTEDVALUE formula to return a URL. Currently this simple formula is just the PBI Service page web address plus the rptfilter - SELECTEDVALUE('Directory'[FullName]). Unfortunately, that doesn't work (apparently because there's a space within the value between first and last name), because if I go to the browser and manually type %27John%20Doe%27 at the end of the URL it DOES! So my question is how surround the FullName with those single quotation marks in my formula? Seems like this should be a simple fix. Thoughts?
Solved! Go to Solution.
You need to add this part marked in red into your DAX formula:
In DAX you append strings using the & operator.
So you can create a new measure like this:
FullNameInSingleQuotes = "'"&SELECTEDVALUE('Directory'[FullName])&"'"
Does this solve the need?
Cheers!
Thank you, powerthru. I'm sure this will work! I'm just not sure how to incorporate your solution into my DAX formula. Currently it reads:
You need to add this part marked in red into your DAX formula:
It WORKS! Thank you so much for your solution!