topic Re: UNABLE TO ADD FILTERS TO BELOW DAX in Report Server

UNABLE TO ADD FILTERS TO BELOW DAX

Anonymous — Thu, 19 Oct 2023 20:40:27 GMT

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]

Re: UNABLE TO ADD FILTERS TO BELOW DAX

d_gosbell — Thu, 19 Oct 2023 21:51:23 GMT

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]

Re: UNABLE TO ADD FILTERS TO BELOW DAX

Anonymous — Fri, 20 Oct 2023 14:04:12 GMT

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