Filter data using slicer

_Flag = --try this might help you
VAR sel = SELECTEDVALUE('Show Categories'[Value])
RETURN
SWITCH(
    TRUE(),

    sel = "Included in MBO" && SELECTEDVALUE(APEX_INTL_MSF_FACT[INCLUDE_IN_MPR]) = TRUE(), 1,

    sel = "Excluded from MBO" &&
        (SELECTEDVALUE(APEX_INTL_MSF_FACT[INCLUDE_IN_MPR]) = FALSE()
        || ISBLANK(SELECTEDVALUE(APEX_INTL_MSF_FACT[INCLUDE_IN_MPR]))), 1,

    sel = "All", 1,

    0
)

hI kunjan_ashara 

Is INCLUDE_IN_MPR a logical (TRUE/FALSE) column or a text column containing the word "TRUE"? If it is a logical type, the values should appear italicized in Data view, and the comparison should use TRUE() rather than "TRUE".

Also, the result of MAX(APEX_INTL_MSF_FACT[INCLUDE_IN_MPR]) can change depending on where the measure is being evaluated. In a visual, each row can have its own filters (for example a specific customer, product, or month), and the measure is calculated only using the data visible for that row.

Hi kunjan_ashara 

 Try this:

Calc_Dax =
VAR Sel =
    SELECTEDVALUE ( 'Show Categories'[Value], "All" )
VAR IncludeFlag =
    MAX ( APEX_INTL_MSF_FACT[INCLUDE_IN_MPR] )
RETURN
SWITCH (
    TRUE(),

    -- Included in MBO
    Sel = "Included in MBO"
        && IncludeFlag = TRUE(), 1,

    -- Excluded from MBO
    Sel = "Excluded from MBO"
        && ( IncludeFlag = FALSE() || ISBLANK ( IncludeFlag ) ), 1,

    -- All
    Sel = "All", 1,

    0
)

 
Once you've added the measure to a slicer, change the visual level filter to 'is 1' in the right hand filter pane as shown in the screenshot

--------------------------------

I hope this helps, please give kudos and mark as solved if it does!

Connect with me on LinkedIn.

Subscribe to my YouTube channel for Fabric/Power Platform related content!

The following replicates your tableau calculation.

Calc_DAX = 
var _paraValue = 
SELECTEDVALUE('Show Categories'[Value])
var _tableValue = 
SELECTEDVALUE(apex_intl_msf_fact[Include_in_mpr])
var _result = 
SWITCH(
    TRUE(),
    _paraValue = "Included in MBO" && _tableValue = TRUE(), TRUE(),
    _paraValue = "Excluded from MBO" && _tableValue IN {FALSE()}, TRUE(),
    _paraValue = "All" && (_tableValue IN {TRUE(), FALSE()} || ISBLANK(_tableValue)), TRUE(),
    FALSE()
)
RETURN
_result

Please try the measure below:

Calc_Dax =
VAR _Sel =
    SELECTEDVALUE ( 'Show Categories'[Value] )
VAR _IncludeFlag =
    MAX ( APEX_INTL_MSF_FACT[INCLUDE_IN_MPR] )
RETURN
    SWITCH (
        TRUE (),
        _Sel = "Included in MBO"   && _IncludeFlag = TRUE (),  1,
        _Sel = "Excluded from MBO" && _IncludeFlag <> TRUE (),  1,
        _Sel = "All",                                            1,
        0
    )

Then apply this measure as a visual-level filter set to is 1 on your visuals.

Hi kunjan_ashara ,

Thank you cengizhanarslan , jgeddes , wardy912 , danextian  for your inputs.
We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Thank you.

Thanks, just adding Include_in_mpr to the rows in the matrix visual solved it.