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.

wardy912's avatar
wardy912
Super User
3 months ago

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!