Forum Discussion
Solved
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 t...
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
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&rptfilterIt WORKS! Thank you so much for your solution!
