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:



      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!