Forum Discussion

Rahul_SC's avatar
Rahul_SC
Icon for Helper IV rankHelper IV
3 years ago
Solved

Replace blank in metrix

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

 

@Dax help

5 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Rahul_SC 

    please try

    IF (

    ISEMPTY ( 'Table' ),

    "No value",

    SUM ( 'Table'[Value] )

    )

    • Rahul_SC's avatar
      Rahul_SC
      Icon for Helper IV rankHelper IV
      3 years ago

      Hi tamerj1 ,

       

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