Select value filter

[Anonymous]

Hello, I have made 2 measures for drill through and its working perfect. The question is about dax if there is a way that i could assign department filter and eliminate clicking manually on table department. A measure that i could duplicate and assign for each of departments

Selected PN =

    var selectedPN =

        SELECTEDVALUE(DimPnRework[pn])

    return

        "pn:"  & IF(ISBLANK(selectedPN), "All pn", selectedPN)

Selected department =

    var selecteddepartment =

        SELECTEDVALUE('pl_master_data bledy_hmd'[dzos])

    return

        "Yield:"  & IF(ISBLANK(selecteddepartment), "All Yield", selecteddepartment)

 

[Anonymous · Accepted solution]

Hi @Anonymous,

AFAIK, the current DAX expressions are not able to affect the filter/slicer selections. You can't use them to change the selection or cancel current activities items.

If you means to ignore the filter interatiosn from a specific field, you can use isfiltered with all functions to ignore specific filters to affect the DAX formula calculations.

ISFILTERED, ISCROSSFILTERED – DAX Guide - SQLBI

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

BTW, selectedvalue function is suitable for single selection, if you selected multiple items without setting 'alternate Result' it will return a blank result. You can try to use the following formula to show current selections:

Selected PN =
VAR selectedPN =
    CONCATENATEX ( VALUES ( DimPnRework[pn] ), [pn], "," )
RETURN
    "pn:"
        & IF (
            COUNTROWS ( VALUES ( DimPnRework[pn] ) )
                = COUNTROWS ( DISTINCT ( ALL ( DimPnRework[pn] ) ) ),
            "All pn",
            selectedPN
        )

Regards,

Xiaoxin Sheng