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.

mh2587's avatar
mh2587
Super User
3 months ago
_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
)