Replacing Blanks with NA in Matrix Visual

[Sam_BI_Analyst]

Hello Community,

I have a matrix visual with blanks in the values. I don't have blanks in my data but they are getting generated because of matrix visual properties. I want to replace the blanks with "NA" based on a condition given below.

Matrix Visual - 

Condition - If the country = US then french column should be NA,

My Dataset - 

My rows and columns - 

Any help would be appreciated.

[Sam_BI_Analyst · Accepted solution]

Never Mind, I got the answer for my question by myself.

The solution i have is to divide my fact table to multiple tables and load it into matrix visual.

Create a new measure - 

sts =

IF(SELECTEDVALUE(subj[Subject])="French" && SELECTEDVALUE(cnt[Country])="US","NA",SELECTEDVALUE(Sheet1[Status]))

load the above measure into values section of matrix visual.

If someone have better solution, please feel free to drop it.