Adding filter to LOD Expression

+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 by Atul
• 5,530 points
58 views

1 answer to this question.

0 votes

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

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

enter image description here

answered Aug 1, 2018 by Atul
• 10,240 points

Related Questions In Tableau

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

answered Apr 9, 2018 in Tableau by xyz
• 1,550 points
3,760 views
0 votes
1 answer

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

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

answered Jun 20, 2018 in Tableau by Atul
• 10,240 points
26 views
0 votes
1 answer

How to hide measures on a Tableau filter?

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

answered Jul 10, 2018 in Tableau by Atul
• 5,530 points
75 views
+1 vote
1 answer

How to add filter on different sheets based on clicks?

Go to Actions… (if you're on a dashboard, you ...READ MORE

answered Aug 1, 2018 in Tableau by Atul
• 10,240 points
43 views
0 votes
1 answer

Exclude LOD -Tableau

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

answered Apr 2 in Tableau by Cherukuri
• 21,350 points
18 views
0 votes
1 answer

Reset filters in Tableau

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

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points
496 views
0 votes
1 answer

How to create a global filter

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

answered Apr 12, 2018 in Tableau by QueenBee
• 1,810 points
41 views
0 votes
1 answer

Creating a calculated field with LOD expression

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

answered Apr 20, 2018 in Tableau by Atul
• 5,530 points
81 views
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

answered Apr 17, 2018 in Tableau by Atul
• 10,240 points
31 views
0 votes
1 answer

How to filter/parameter for different date ranges

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

answered Jun 20, 2018 in Tableau by Atul
• 10,240 points
553 views