How to flag the "Zero" rows but ignore the Blank rows

[PBI_newuser]

Hi, I have the below sample dataset and i wish to flag those NPS between 0 to 6 as 1, but the below column doesn't work.

It considered 0 and BLANK as the same value. 

Detractor Flag = 
IF('Table'[NPS]=BLANK(),BLANK(), 
      IF('Table'[NPS]>=0 && 'Table'[NPS]<=6,1
         ,0))

Serial Number	NPS	Detractor Flag	Expected Output for Detractor Flag
SN-111
SN-222	0		1
SN-333	4	1	1
SN-444	0		1
SN-555	5	1	1

[CNENFRNL]

Flag = 
IF(
    NOT ISBLANK( 'Table'[NPS] ),
    IF( 'Table'[NPS] * ( 'Table'[NPS] - 6 ) <= 0, 1, 0 )
)

[Jihwan_Kim · Accepted solution]

Hi, @PBI_newuser 

Please try the below.

instead of =blank() , try ==blank()

Detractor Flag CC =

IF('Table'[NPS]==BLANK(),BLANK(),

IF('Table'[NPS]>=0 && 'Table'[NPS]<=6,1

,0))

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM