Help with Web URL Measure only when cells are not blank

[JSWILCOX1980]

My table data consists of text column where there are a list of Text Entries, not every row has data.

Fruit

apples

strawberries

grapes

oranges

I have a used this measure for Web URL's 

Web URL3 = "https://mywebsite.com/browse/" & MAX('Test'[Fruit])

Which returns these results:

what i would like to achieve is within the measure, to have an If Statement that says if Fruit column contains blanks then do not return URL

Any help or guidance would be greatly appreciated.

[Ritaf1983 · Accepted solution]

Hi @JSWILCOX1980 
Modify the measure for :

Web URL4 = if (ISBLANK( max('Test'[fruits])), "","https://mywebsite.com/browse/" & MAX('Test'[fruits]))

or :

Web URL3 = if ( max('Test'[fruits])= "", "","https://mywebsite.com/browse/" & MAX('Test'[fruits]))

Depends on the reason for the blanks in the visual

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

[JSWILCOX1980]

Rita, This was fantastic and so simple, i was trying to make much more difficult than what you provided!  I used your first suggestion and it worked flawlessly.  I am actually quantifying Jira Data and Not every entry is linked to an Epic, so if that data wasnt entered it doesnt exist, that is the reason for the blanks,  It can and should be updated by my team to have this data so the first solution will work once we have that running.  Again, Thank you!

[Ritaf1983]

Hi @JSWILCOX1980 

Glad to help 🙂

There is a philosopher who said that life is not as simple as we think, but much simpler.❤️