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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
JustinDoh1
Post Prodigy
Post Prodigy

How to not display "0" output if there is no matching?

I have 4 level of hierarchy of data I am displaying as shown below:

 

JustinDoh1_0-1737669677254.png

 

From 2.Payer --> 4.PatientName, these data come from a same fact table.

What I am trying to do is, not showing any 4.PatientName if there is no match in those time periods.

So, if there is 0 for a lot of patients here, I do not want to display their patient names.

 

What is common way of handling this? 

Thanks.

 

 

1 ACCEPTED SOLUTION
Uzi2019
Super User
Super User

Hi @JustinDoh1 

 

Just use filter of Decimalfix >0 .

 

Uzi2019_0-1737706349587.png

 

 

I hope this might help!

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

View solution in original post

10 REPLIES 10
Uzi2019
Super User
Super User

Hi @JustinDoh1 

 

Just use filter of Decimalfix >0 .

 

Uzi2019_0-1737706349587.png

 

 

I hope this might help!

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

@Uzi2019 I found a solution using a measure called "Average" (that was used before a measure "decimalFix" was applied on the visual).  The issue that I encountered was "decimalFix" is currently in a "Text" data type, so I could not use that as you indicated. But when I added the this conditon with "Average" on the visual, it worked out:

JustinDoh1_0-1737761223757.png

Thanks.

Hi @JustinDoh1 

 

Or add blank filter also

 

Uzi2019_1-1737706508411.png

 

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Hi @JustinDoh1 

 

Try this measure also

 

Measure = IF(SELECTEDVALUE('Table'[DecimalFix]) = "0.00" || SELECTEDVALUE('Table'[DecimalFix]) = BLANK(),0,1)

 

Apply his filter to visual

 

Uzi2019_0-1737706699917.png

 

 

I hope this might be helpful.

 

I hope I answered your question!

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
ray_aramburo
Super User
Super User

The measure you are using most likely has a logic of either a) IF(ISBLANK(Sum or Count Expression), 0, (Sum or Count Expression)) or b) [Sum or Count Expression Measure] + 0. 

To handle it just use a simple measure that doesn't add 0 or evaluates for blanks. You can also add a visual filter to remove the zeros like this:

ray_aramburo_0-1737671443163.png

 





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





@ray_aramburo Thanks for help. Actually, I am just bring the "4.PatientName" from a column, not a measure. Should I create a measure for this column then?

The Patient Name is not the issue since it's the dimension, is the values field in the matrix you have to address (the one that produces 0 or the other desired quantities)





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





@ray_aramburo  Sorry.  Can you please elaborate little bit?  Regards to 'dimension', are you saying, I have to create a separate dataset for PatientName instead of using the value from this Fact table?

Hi! Sorry for the confusion! No, you don't have to separate it. Can you tell me which field do you have in Values? I'm assuming the PatientName is on the Rows. 





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





@ray_aramburo I wish I could create a sample PBIX file (maybe by tomorrow), but here is snapshot of rows, columns and values:

JustinDoh1_0-1737677462639.png

 

decimalFix is a measure:

 

decimalFix =
if(DISTINCTCOUNT(DimDate1[DateFormat])=1,
format([Average],"0"),
format([Average],"0.0")
)

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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