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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi faroby ,

1.Enter data:

2. New a measure:

FLAG = IF(HASONEVALUE(XXX_Countries_OK[country]),SELECTEDVALUE(XXX_Countries_OK[image_url],MAX('Table'[URL])))

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

faroby's avatar
faroby
Regular Visitor
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