concatinated string to image url not working

[klaudiusze4t]

I'm fetching data from openweathermap api. Then I'm trying to create image url string to fetch image:
```

ImageUrl = "https://openweathermap.org/img/wn/" & CALCULATE(

    FIRSTNONBLANK(Weather[list.weather.icon], 1),

    Weather[list.dt_txt] = MIN(WeatherWrzesnia[list.dt_txt])) & "@2x.png"

```
Image doesnt load, when printing ImageUrl to text field ive got 

```

https://openweathermap.org/img/wn/13d@2x.png

```

after pasting that to browser I cant get image. In address input it's changing to 

```

https://www.google.com/search?q=%EF%BB%BFhttps%3A%2F%2Fopenweathermap.org%2Fimg%2Fwn%2F13d%402x.png%...

```

After retyping manually to the browser url works. Powerbi somehow destroy my ulr.

[Bibiano_Geraldo · Accepted solution]

Hi @klaudiusze4t ,

if its returning this:

https://openweathermap.org/img/wn/13d@2x.png

its mean that your calculate is returning blank as result, lets breakdown this.

1- I'm supposing that you're in WeatherWrzesnia table, where you want to create a calculated column ImageUrl.
2- with this, you can create a new calculated column using this DAX:

ImageUrl =
    "https://openweathermap.org/img/wn/" &
    CALCULATE(
        FIRSTNONBLANK(Weather[list.weather.icon], 1),
        FILTER(
            Weather,
            Weather[list.dt_txt] = WeatherWrzesnia[list.dt_txt]
        )
    ) &
    "@2x.png"

I'm not using MIN function, because calculated columns works in row context also.

let me now if this help you, try to debbug your DAX to see what the calculate returns.

[klaudiusze4t]

Works, thank u

[danextian]

Hi @klaudiusze4t 

Is this the output of your measure as a text?

https://openweathermap.org/img/wn/13d@2x.png

Because this loads fine in Power BI after changing  its data category to image URL. What is the result of this calculation?

CALCULATE(
    FIRSTNONBLANK(Weather[list.weather.icon], 1),
    Weather[list.dt_txt] = MIN(WeatherWrzesnia[list.dt_txt]))

[klaudiusze4t]

funny that after pasting invalid url here it validated. raport still not working tho