Forum Discussion
Help with Web URL Measure only when cells are not blank
- 2 years ago
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
Hi JSWILCOX1980
Modify the measure for :
If 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!
- Ritaf19832 years ago
Super User
Hi JSWILCOX1980
Glad to help 🙂
There is a philosopher who said that life is not as simple as we think, but much simpler.❤️