Menu
    KNOWLEDGE BASE

    Action Filter Sending FIXED Expression Returns Unexpected Values

    Published: 22 Jun 2018
    Last Modified Date: 25 Jun 2018

    Issue

    When using a filter action with a FIXED expression from a worksheet with a context filter, sent values may not match on target worksheet.

    Environment

    Tableau Desktop

    Resolution

    Use the same context filter on the target worksheet, or use a different dimension for sending the filter action.

    Cause

    In an example where: 
    • Name] = 'Sam' and [Fixed Value] = 2 on entire data source
    • Source worksheet has a context filter that causes [Fixed Value] to be 1
    When action filter is triggered to worksheet without said context filter, 'Sam' and 1 are sent, but the target worksheet only knows of 'Sam' with value of 2, so 'Sam' gets filtered out.
    Did this article resolve the issue?    
    PRINT THIS PAGE
    Related Links
    Fixed LOD
    Tableau Order of Operations
    Calculations with Fixed Expression Return Unexpected Results When Filtered
    Attachments

    All Support

    SUPPORT BY PRODUCT
    TOOLS & DOWNLOADS
    INFORMATION
    ASSISTANCE