Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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:
Hello,
late reply but I had to deal with this issue today.
So, for other readers, I have done as follow :
Just replace in your URL the " by %22
it works,
Regards,
Roland.
It WORKS! Thank you so much for your solution!
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
74 | |
60 | |
59 |