+1 vote
`Dataset:`
```Product     Item    Status

A            aa     0

A           aaa     0

A           aaaa    0

A          aaaaa    1

B            bb     2

B           bbb     0

B           bbbb    3

C            cc     4

C           cccc    5
```

What I want?

Calculate the count of items which have status = '0' at the Product level.

Expected Output:

```Product        Count

A                3

B                1
```

My formula is as follows:

```{FIXED [Product]: CountD([Item) }
```

and I dragged the status into filters.

But this is not working. Can someone help?

Aug 1, 2018 in Tableau 889 views

## 1 answer to this question.

0 votes

{ FIXED [Product]:COUNT(IF [Status]=0 THEN [Status] END)}

Edit-------------------------------------------------------------

answered Aug 1, 2018 by
• 10,240 points

0 votes
1 answer

## Adding new filter to an existing dashboard on Tableau

By clicking the down arrow on the ...READ MORE

0 votes
1 answer

## How to use LOD to count distinct number of records based on some condition?

From the desired output it seems that ...READ MORE

0 votes
1 answer

## How to add filter to show latest two dates in tableau?

Steps for filtering based on the most ...READ MORE

0 votes
1 answer

## How to hide measures on a Tableau filter?

Number of Records is just a predefined ...READ MORE

0 votes
1 answer

## Exclude LOD -Tableau

Hi Nikki, You can try this,  { EXCLUDE : ...READ MORE

0 votes
1 answer

## Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

0 votes
1 answer

## How to create a global filter

Assuming you have created a dashboard already, ...READ MORE

0 votes
1 answer

## Creating a calculated field with LOD expression

Go ahead and try the following three ...READ MORE

0 votes
1 answer

## Is it possible to apply filter just to one of the measures

Hey @Ghost, Why don't you use Level of Detail ...READ MORE

0 votes
1 answer

## How to filter/parameter for different date ranges

Steps: Create a parameter control that the users ...READ MORE