Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need help to create a URL measure based on other fields

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 🙂 

Need Help

1 Reply

  • lucadelicio's avatar
    lucadelicio
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    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