6 Replies Latest reply on Dec 6, 2016 5:34 PM by Shinichiro Murakami

    Filter on Measure Calculation

    David Edwards

      Hi Tableau Gurus,

       

      I've got a very simple question, that I can't seem to figure out.

       

      I've got a database of Stores, model numbers, and sales. Example:

      StoreModel
      Sales
      1234X2
      1233Y-1
      1244X5

       

      For this particular task, I'm only looking at the sales for 2 models numbers. The sales values vary from negative to positive number (including zeros). I'm trying to look for stores that have bought both models, so sales have to be at least 1.

       

      I was hoping to make a calculation that I can filter on, but I can't figure out the calc. Any help would be greatly appreciated!