Replace blank in metrix

[Rahul_SC]

Hi,

I want to replace blank values with "No value" in metrix table. I am using some if condition to filll it or used coalesce dax also. But not able to fill blank values with alternative values. Below is the table structure, I have. 

This is the metrix, not sure how this blank value can be filled with any other alternative value. 

Thanks

[Rahul_SC]

@tamerj1 , thanks! at least for now I can use this way to get the same output.

[tamerj1]

Hi @Rahul_SC 

please try

IF (

ISEMPTY ( 'Table' ),

"No value",

SUM ( 'Table'[Value] )

)

[Rahul_SC]

Hi @tamerj1 ,

I had tried this, and again tried it. It is still give empty value.

[tamerj1 · Accepted solution]

@Rahul_SC 

Use a dim table for for week number. 

[Rahul_SC]

Hi @tamerj1 , thanks, now, it works.

but it must work without dim table. Because I need to use any other catogorical column. 

Let's say, If I have a column where names are there (ex - A, B, C, D ----etc.). then I want to make it work ? how we can do that ?