Forum Discussion
Quotation Marks in DAX Measure for URL
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?
You need to add this part marked in red into your DAX formula:
Filtered URL Pass =var rpturl = "https://app.powerbi.com/groups/me/reports/587ce61e-d2bd-43b6-b5d4-83d9e84676fc/ReportSectionc1a4fd29..."var rptfilter = "Directory/FullName eq "&"'"&SELECTEDVALUE('Directory'[FullName])&"'"returnrpturl&rptfilter
6 Replies
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:
Filtered URL Pass =var rptfilter = "Directory/FullName eq "&SELECTEDVALUE('Directory'[FullName])returnrpturl&rptfilterThis formula returns the following URL link:https://app.powerbi.com/groups/me/reports/587ce61e+d2bd-43b6-b5d4-83d9e84676fc1a4fd29OdO4c1299e?experience-power-bi?filter _ Directory/FullName eq (followed by the SELECTEDVALUE currently returning as John Doe, but needs to be 'John Doe' to work).Please let me know what I need to change.Thanks SO much!You need to add this part marked in red into your DAX formula:
Filtered URL Pass =var rpturl = "https://app.powerbi.com/groups/me/reports/587ce61e-d2bd-43b6-b5d4-83d9e84676fc/ReportSectionc1a4fd29..."var rptfilter = "Directory/FullName eq "&"'"&SELECTEDVALUE('Directory'[FullName])&"'"returnrpturl&rptfilter
