Need Help To Get Last Record Based On Column Value

This query should return the Active row if we have one otherwise returns the latest row based on Last_Modified_Date.

;WITH StatusRanking AS (
    SELECT 
        c_ID, 
        [C_Name], 
        [Active/InActive] , 
        Last_Modified_Date,
        ROW_NUMBER() OVER (
            PARTITION BY C_ID 
            ORDER BY 
                CASE 
                    WHEN [Active/InActive]  = 'Active' THEN 1 
                    ELSE 2 
                END, 
                Last_Modified_Date DESC
        ) AS RowNum
    FROM #T
)
SELECT 
    C_ID, 
    [C_Name], 
    [Active/InActive], 
    Last_Modified_Date, RowNum
FROM StatusRanking
WHERE RowNum = 1;