Forum Discussion
PCorbitt
Helper I
3 years agoQuotation 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...
- 3 years ago
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
poweringthru
Helper I
3 years agoIn 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!