How can I create a DAX measure that is a string url that references another column?

[chrisl_jffd]

I am trying to create a DAX Measure in my Fabric Power BI Model. I want to use this column to build a url from the id column so I can use it to conditionally format the id in a report table as a url. I can't figure out how to reference the id column correctly. I know you can use SUM to reference other column types, but my id column is a string and SUM wont work.

link = "https://xxxxxx.lightning.force.com/lightning/r/OrderSummary/" & SELECTEDVALUE(salesforce_order_summary[id]) & "/view"

The above just results in: https://xxxxxx.lightning.force.com/lightning/r/OrderSummary//view

[lbendlin · Accepted solution]

SELECTEDVALUE returns BLANK if it doesn't find exactly one value. Evaluate why you have multiple values selected, and consider using an aggregate like MIN or MAX if applicable.

[chrisl_jffd]

Does MIN/MAX work with a string? I did figure out what was wrong, I had a type in the column name.

[lbendlin]

yes, MIN/MAX works with strings