Forum Discussion
Help with Web URL Measure only when cells are not blank
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
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.
Hi JSWILCOX1980
Modify the measure for :Web URL4 = if (ISBLANK( max('Test'[fruits])), "","https://mywebsite.com/browse/" & MAX('Test'[fruits]))or :Depends on the reason for the blanks in the visualIf this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
3 Replies
- Ritaf1983
Super User
Hi JSWILCOX1980
Modify the measure for :Web URL4 = if (ISBLANK( max('Test'[fruits])), "","https://mywebsite.com/browse/" & MAX('Test'[fruits]))or :Depends on the reason for the blanks in the visualIf this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
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.❤️
