Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

 


 

11 REPLIES 11
Herritage_95
Frequent Visitor

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

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.