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

# Filter on Measure Calculation

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!

• ###### 1. Re: Filter on Measure Calculation

Hmm, I'm not certain but this seems to be the second time I've read this same question. Yes? I didn't answer it the first time because you didn't take the time to create and attach a sample workbook. Do that and I'm sure you'll get an answer to your question.

Cheers,

--Shawn

• ###### 2. Re: Filter on Measure Calculation

Shawn,

This is the first time I've posted this question (see picture attached).

I didn't post a workbook because this seems very simple, even with the sample table that I posted. If it's required to get the question answered, I'll recreate my issue with the Superstore data.

• ###### 3. Re: Filter on Measure Calculation

As Shawn said, we prefer that you prepare the packaged workbook always.

For this request, data set might be minimal and I already worked on that and now attaching packaged workbook with sample data.

But Please remember in any case, we want requester prepare packaged workbook.  please go thru the link I attached.

Packaged workbooks and flows: when, why, how

Data I prepared,

[Countd >1]

countd(if [Sales] >=1 then [Model] end)

Thanks

Shin

1 of 1 people found this helpful
• ###### 4. Re: Filter on Measure Calculation

David Edwards wrote:

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:

Store
Model
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!

Your example data does not include 'stores that have bought both models'. So, yes a sample workbook would be helpful.

--Shawn

--Shawn

• ###### 5. Re: Filter on Measure Calculation

Thanks Shin! This worked great!

• ###### 6. Re: Filter on Measure Calculation

You are welcome.

Thanks,

Shin