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.

jgeddes's avatar
jgeddes
Super User
3 months ago

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