Incorrect Sorting While Using Secondary Data Source Filters

Published: 24 Nov 2015
Last Modified Date: 08 Aug 2016


When you filter a view by a field from a secondary data source, the sorting in your view might appear to be incorrect. 


Tableau Desktop


Option 1

Create a formula similar to: RANK_UNIQUE(SUM([Measure]))

Option 2

Add the field being filtered from the primary data source to the view.


When filtering on a field from a secondary data source, the data is hidden, rather than filtered out. Because the sort is based on the underlying data in the primary data source, the resulting values in the view appear to sort incorrectly.

Additional Information

For more information, see the example workbook available in the attachment section of this article. 
Did this article resolve the issue?