Replace cell value in Power BI Matrix Visual cell value

[Anonymous]

I have a matrix visual as shown below. When i drag my values inside this visual , i see that some of the cells i.e

A->feb

A->mar

are blank as shown in the image below (current output) . This is not a measure so i cannot add 0 as shown in many other example. I created a separated column with the following function  

BLANK = IF(ISBLANK('Table'[Value]),"not scan",'Table'[value])

but its not working. I want the matrix visual to show me the values as shown in the image expected output. 

How can i achieve it?

[Anonymous · Accepted solution]

I managed to solve this problem by refering to this link, which was nicely explained and the example that was attached helped a lot. 

How to replace empty cells in matrix with another ... - Microsoft Power BI Community

[mariussve1]

Hi,

Strange, can you please try this:

Measure =

Var scan = SELECTEDVALUE ( Table[value] )

Return
IF ( scan = BLANK (), "not scan", scan )

[Anonymous]

@mariussve1  Thank you for you kind reply. I tried your solution but it did not work. I think the problem is how to tell the formula that the cell between  (A-->F) within the matrix is empty? Another thing is value is Text and not numeric so not sure if the measure will work.