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
Maru
Helper I
Helper I

Filter does not work properly (blank case)

You can see that there are some rows with blank although filter only 0%.

Maru_1-1701076177205.png

At he beginning, I thought it was DAX measure thing but it works fine on 'Table View' (filter 0% there will be no index 319824)

Maru_4-1701076410479.png

 

 

Fortunately, I found that it this will work if use this setting.

Maru_0-1701075280731.png


Am I missing something here ?


1 ACCEPTED SOLUTION
speedramps
Super User
Super User

You need to grasp the difference between zero and blank.

If I have 2 apples and I give you 2 apples then my outbound = 100%

If I have 2 apples and give you 1 then my outbound = 50%

If I have 2 apples and give you none then my outbound = 0%

If I have 1 apple and give you 1 then my outbound = 100%

If I have 1 apple and give you none then my outbound = 0%

If I have no apples then my outbound is blank  because I have nothing to give !

It is basic maths but many BI novices stuggle with this simple concept of zero vs blanks.

 

Please click "accept as soluton" and the thumbs up buttons

View solution in original post

4 REPLIES 4
Maru
Helper I
Helper I

What @speedramps  mentioned would be this

 

Implicit Conversion: Power BI may perform implicit conversions behind the scenes. For example, if you have a column with a mix of numbers and blanks, Power BI might internally convert the blanks to zeros when filtering for zero.

speedramps
Super User
Super User

You need to grasp the difference between zero and blank.

If I have 2 apples and I give you 2 apples then my outbound = 100%

If I have 2 apples and give you 1 then my outbound = 50%

If I have 2 apples and give you none then my outbound = 0%

If I have 1 apple and give you 1 then my outbound = 100%

If I have 1 apple and give you none then my outbound = 0%

If I have no apples then my outbound is blank  because I have nothing to give !

It is basic maths but many BI novices stuggle with this simple concept of zero vs blanks.

 

Please click "accept as soluton" and the thumbs up buttons

Oh, I didn't expect this implication. 

Filtering of when you give 0 apple also include a case when you don't have apple ! 
The checkbox is not check though.

However, seems you are right since changing from 0 to 0.1 no longer include blank. 

Maru_0-1701141232079.png

 



Ritaf1983
Super User
Super User

Hi @Maru 

Try to create a flag measure like 
if isblank([filloutbound] || [filloutbound] = "", 1,0)
and filter your visual by this flag.

** [filloutbound] should be a measure.
if it isn't help 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickl

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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!

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.