Forum Discussion

faroby's avatar
faroby
Regular Visitor
3 years ago
Solved

Default image URL in an IF statement

I have the following expression in a mesure that selects an image URL of a flag from a table, but when it is FALSE it does't show the default image.   FLAG = IF(HASONEVALUE(XXX_Countries_OK[countr...
  • faroby's avatar
    faroby
    3 years ago

    Thank you, the idea of inserting the default value in a new table is OK, but for me it works with the following script:

    Selected FLAG = IF(HASONEVALUE(XXX_Countries_OK[country]), SELECTEDVALUE(XXX_Countries_OK[image_url]), MAX('Table'[URL]]))
    The default value must be inside the IF statment not in the SELECTEDVALUE function

parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

faroby I guess you are adding this as a measure, did you change the category of the measure to image URL?

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.