Forum Discussion
Filter does not work properly (blank case)
- 2 years ago
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
- 2 years ago
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
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.