Forum Discussion
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...
Thanks, just adding Include_in_mpr to the rows in the matrix visual solved it.
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.