Forum Discussion

kunjan_ashara's avatar
kunjan_ashara
New Member
3 months ago
Solved

Filter data using slicer

Hello Everyone,  I have this tableau calculation where [Include in MPR Para] is a Tableau parameter and INCLUDE_IN_MPR is a column. if [Include in MPR Para] = 'Included in MBO' and ([INCLUDE_IN_M...
Need Help
  • kunjan_ashara's avatar
    kunjan_ashara
    3 months ago

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

cengizhanarslan's avatar
cengizhanarslan
Super User
3 months ago

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.