UNABLE TO ADD FILTERS TO BELOW DAX

[Anonymous]

i wanted to filter the data in the below DAX in (power bi paginated reports) for the  ('CombineDataSet'[Project Name] in ('115001' and  '115002') 

i tried different syntax but none of them are working will be greatful if some on ec can help on this..

EVALUATE SELECTCOLUMNS (ADDCOLUMNS (SUMMARIZECOLUMNS (ROLLUPADDISSUBTOTAL ('CombineDataSet'[Project Name], "h0")), "ParameterLevel", if ([h0], 0, 1)), "ParameterCaption", SWITCH([ParameterLevel], 1, 'CombineDataSet'[Project Name], "Blank()"), "ParameterValue", 'CombineDataSet'[Project Name], "ParameterLevel", [ParameterLevel], "'CombineDataSet'[Project Name]", 'CombineDataSet'[Project Name])
order by 'CombineDataSet'[Project Name], [ParameterLevel]

[Anonymous]

Thank you @d_gosbell  that worked and thats a great help will be greatful for the same..😊

[d_gosbell · Accepted solution]

The easiest way to do this is probably to use the TREATAS function and pass this as a filter table in the SUMMARIZECOLUMNS function

EVALUATE
SELECTCOLUMNS (
    ADDCOLUMNS (
        SUMMARIZECOLUMNS (
            ROLLUPADDISSUBTOTAL ( 'CombineDataSet'[Project Name], "h0" ),
            TREATAS({"115001", "115002"}, 'CombineDataSet'[Project Name] )
        ),
        "ParameterLevel", IF ( [h0], 0, 1 )
    ),
    
    "ParameterCaption", SWITCH ( [ParameterLevel], 1, 'CombineDataSet'[Project Name], "Blank()" ),
    "ParameterValue", 'CombineDataSet'[Project Name],
    "ParameterLevel", [ParameterLevel],
    "'CombineDataSet'[Project Name]", 'CombineDataSet'[Project Name]
)
ORDER BY
    'CombineDataSet'[Project Name],
    [ParameterLevel]