5 Replies Latest reply on Apr 15, 2019 5:13 PM by Shinichiro Murakami

    Exclude a filter from one calculation, but apply to entire sheet

    Lazy Rambler

      In the attached workbook, with Superstore dataset, I have applied the filter of Category;Technology. I also created a new calculation called 'Furniture Sales' to get just the furniture sales.

       

      Is there any way for the Furniture sales calculated field, to show just the Sales for furniture category, with the Sales measure showing value for Technology? I can create a new calculation called Technology calculation, and it will work fine, but I want to explore this option too. Having a filter which will affect multiple measure, and not one the ones I want.