sql where in dax equivalent

Replace filter with calculatetable command :}

EVALUATE 
--    FILTER ( 
    CALCULATETABLE ( 
        SELECTCOLUMNS (
             'CPP Traffic Light Short Status',
             "Short Status Name",   'CPP Traffic Light Short Status'[Short Status Name],
             "Unichar Glyph",       UNICHAR ('CPP Traffic Light Short Status'[Unicode Decimal]),
             "Colour Hex",          'CPP Traffic Light Short Status'[Colour Hex], 
             "Font Size",           'CPP Traffic Light Short Status'[Font Size], 
             "Font Size Offset",    'CPP Traffic Light Short Status'[Font Size Offset] 
        ),
        'CPP Traffic Light Short Status'[Status Code] IN {0, 1, 2, 3, 10}
--        'CPP Traffic Light Short Status'[Status Code] = 0
--          'CPP Traffic Light Short Status'[Short Status Name] = "Not Reported"
    )
ORDER BY [Short Status Name]