Percent Change calculation = to 0 being treated as blank

[doubles]

I am having an issue ranking a percent change calculation becasue when I have a percent change of 0, it is being treated as blank.  In the screen shot, you can see there are 2 categories where my prevyear and curryear counts are the same and therefore the % change is 0. My RankX formula is below -- it does what I want, except its treating the 0% changes as blanks. I created 2 simple measures Test0 and TestBlank  -- IF([PercentChange] = blank(),1,0) -- IF([PercentChange] = 0,1,0) and you can see 0s and blanks are returning 1s. Any insight would be appreciated. Thanks

Rank= 
IF (
 [PercentChange] = BLANK (),
 BLANK (), 
 RANKX (
 FILTER (
 ALL ( Category[Value] ),
 [PercentChange] <> BLANK ()
 ),
 [PercentChange]
 )
)

[doubles · Accepted solution]

Looks like using ISBLANK, rather than = blank() solves the issue.

https://stackoverflow.com/questions/51756571/powerbi-differentiate-blank-value-and-0-value