Replace blank value with 100% for a measure in the matrix

[Anonymous]

Hi,

I am trying to replace blank values for the ACTUAL column (which I created using new measure) in my matrix with the value 100% but I am not able to. I tried the following code, but it doesn't make any changes to matrix:

Measure = IF ( ISBLANK([Actual]), "100%", [Actual])

Please help!

[Herritage_95]

Good day i have a similar problem , where there is blanks i want it to show as 100% uptime, please assist

[Anonymous]

Hi! Do you have answer for this? I have the same issue.

[Anonymous]

What about if you do it as a Calculated Column as:

= IF ( ISBLANK([Actual]), 1, [Actual])

I am assuming [Actual] is a value and not text here.

[Anonymous]

@Anonymous 

Agree, we need to see your table not just the matrix visual, dax is based on the data table not report visuals.

Paul Zheng _ Community Support Team

[Angith_Nair]

Hi @Anonymous ,

Could you please share the pbix file so that I can look into it..?

[Anonymous]

Hi,

Please find the link.

https://capgemini-my.sharepoint.com/:u:/r/personal/mansi_a_agarwal_capgemini_com/Documents/Desktop/O... 

[Anonymous]

Sorry I cannot share the pbix file due to security issues. Is there any other option?

[Tim_H]

Is your column with data blank or 'null' ?

[Anonymous]

It is blank. There is no data to show there so i want to show 100% in those rows.

[Anonymous]

Hello @Anonymous ,

 Create a column and try once,

Column = IF ( ISBLANK([Actual]), "100%", [Actual])

[Anonymous]

I have already tried it. Its showing the same result as actual column. No change.