Forum Discussion

JSWILCOX1980's avatar
JSWILCOX1980
Regular Visitor
2 years ago
Solved

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 mea...
  • Ritaf1983's avatar
    2 years ago

    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