Quotation Marks in DAX Measure for URL

[PCorbitt]

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?

[poweringthru]

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!

[PCorbitt]

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 rpturl = "https://app.powerbi.com/groups/me/reports/587ce61e-d2bd-43b6-b5d4-83d9e84676fc/ReportSectionc1a4fd29..."

var rptfilter = "Directory/FullName eq "&SELECTEDVALUE('Directory'[FullName])

return

rpturl&rptfilter

This formula returns the following URL link:

https://app.powerbi.com/groups/me/reports/587ce61e+d2bd-43b6-b5d4-83d9e84676fc1a4fd29OdO4c1299e?expe... _ 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!

[poweringthru · Accepted solution]

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])&"'"

return

rpturl&rptfilter

[Cobalt2234]

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.

[PCorbitt]

It WORKS! Thank you so much for your solution! 

[NaveenGandhi]

Hello @PCorbitt 

Can you post sample data to understand this better?

Regards,

Naveen