Return a certain base 64 icon if a measure is null.

[Anonymous]

I have a measure like this.

 Product[Icon] = IF ( Product[Version] > 1, Product[ProductIcon1], Product[ProductIcon2] )

What currently happens since it is a new product, sometimes the Icons are not created yet. What I would like to do is have a generic icon show up if the result of the above measure is null.  The Icons are stored in the Product table in Base 64 format.  

Any Advice on doing this?

[123abc]

Certainly! To achieve this, you can modify your existing DAX measure to include logic that checks if the result is null and, in that case, returns the base 64 representation of your generic icon. Here's an example

Product[Icon] =
IF (
NOT ISBLANK ( Product[Version] )
&& ( Product[Version] > 1 )
&& NOT ISBLANK ( Product[ProductIcon1] ),
Product[ProductIcon1],
IF (
NOT ISBLANK ( Product[Version] )
&& ( Product[Version] > 1 )
&& NOT ISBLANK ( Product[ProductIcon2] ),
Product[ProductIcon2],
"base64_representation_of_generic_icon"
)
)

In this example, if Product[ProductIcon1] is not blank and the version condition is met, it will use ProductIcon1. If not, it checks for Product[ProductIcon2]. If that is also blank or the version condition is not met, it returns the base 64 representation of your generic icon.

Make sure to replace "base64_representation_of_generic_icon" with the actual base 64 representation of your generic icon.

[Anonymous · Accepted solution]

I will have to try this way and see how it works. 

What I have tried and seems to be working is.

 Product_Blank =
     IF ( [Product[Icon] == "", [Product_Icon_not_found], Product[Icon] )