How To Apply A Filter Only To A Single Measure In The View

Published: 20 Aug 2020
Last Modified Date: 08 Jul 2022


How to apply a filter only to a single measure in the view. Example: Showing Sales for a selected category and Total sales


  • Tableau Desktop


1. Use Fixed calculation for the measure you do not want to be affected by filter. Example: Total Sales would be { Fixed: Sum( Sales) }
2. Use Sum(Sales) as it is for the other measure 
3. Use the Category filter. This will filter sum of sales and not the Total Sales
User-added image
Did this article resolve the issue?