cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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!
 
mansagar_1-1616579058354.png

 


 

10 REPLIES 10
marts
New Member

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

BrentCo
Frequent Visitor

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.

V-pazhen-msft
Community Support
Community Support

@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
Resolver II
Resolver II

Hi @Anonymous ,

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

 

Anonymous
Not applicable
Anonymous
Not applicable

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

 

Tim_H
Helper I
Helper I

Is your column with data blank or 'null' ?

Anonymous
Not applicable

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

 

Krutigawale33
Responsive Resident
Responsive Resident

Hello @Anonymous ,

 Create a column and try once,

 

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

Anonymous
Not applicable

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

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors