Need help to create a URL measure based on other fields

[Hanto]

I have a field which follows the layout as follows: ID-Name (i.e. 123-henry)

I want to (for example above) create a URL Measure that looks like this: app.powerbi.com/ID=123.

I tried this DAX syntax (Kudos ChatGPT):

URL Measure = "app.powerbi.com/ID=" & SUBSTITUTE([ID-Name field], "-", "") 

And got the following error:

"(...) a measure formula refers to a column that contains many values without specifying an aggregation (...)"

Pls help 🙂 

[lucadelicio]

You could try to create a calculated column with the same code.

Then you can use the new filed.

Mark as solution if i help you.

Ciao