topic Re: How can I create a DAX measure that is a string url that references another column? in DAX Commands and Tips

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

chrisl_jffd — Sat, 29 Jun 2024 21:59:42 GMT

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

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

lbendlin — Sun, 30 Jun 2024 00:59:12 GMT

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.

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

chrisl_jffd — Sun, 30 Jun 2024 01:04:01 GMT

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

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

lbendlin — Sun, 30 Jun 2024 01:06:51 GMT

yes, MIN/MAX works with strings