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?