Here is the answer that worked, thank you very much for your help
SELECT ROW_NUMBER() OVER(PARTITION BY SomeVal ORDER by case when SomeVal IS NULL THEN 1 ELSE 0 END)