Forum Discussion
Filter does not work properly (blank case)
You can see that there are some rows with blank although filter only 0%.
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)
Fortunately, I found that it this will work if use this setting.
Am I missing something here ?
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 helpPlease 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/1447523If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickl
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
4 Replies
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 helpPlease 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/1447523If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickl
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.
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.