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
zzinoun
Resolver I
Resolver I

Text display measure (blank field)

Hi,

 

I am trying to put a text in blank fields based on a measure "Volume" (Volume Lay out)

zzinoun_0-1653403615236.png

 

I have created a second measure for that: 

Volume Lay out (test) = if(ISNUMBER([Volume Lay out])=True(),[Volume Lay out],"Missing Data")
where volume lay out is the original measure .
The issue here is the measure does not change only the filtered rows but display all the available rows which is annoying (picture bellow)

 

zzinoun_2-1653403976643.png

 

how can I resolve this ?

 

Thanks,

1 ACCEPTED SOLUTION
zzinoun
Resolver I
Resolver I

Actually it was due to not matching items between tables . Thanks though 😄 

View solution in original post

2 REPLIES 2
zzinoun
Resolver I
Resolver I

Actually it was due to not matching items between tables . Thanks though 😄 

vojtechsima
Memorable Member
Memorable Member

Hi, @zzinoun 
you can put filter into your visual that will display only the Missing Data, put your measure into Filter Pane like this:

vojtechsima_0-1653404638378.png

 

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.