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,550 points
411 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,230 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,560 points
15,355 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 21, 2018 in Tableau by Atul
• 10,230 points
332 views
0 votes
1 answer

How to hide measures on a Tableau filter?

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

answered Jul 11, 2018 in Tableau by Atul
• 5,550 points
1,237 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,230 points
296 views
0 votes
1 answer

Exclude LOD -Tableau

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

answered Apr 2, 2019 in Tableau by Cherukuri
• 33,010 points
138 views
0 votes
1 answer

Reset filters in Tableau

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

answered Mar 30, 2018 in Tableau by QueenBee
• 1,820 points
2,861 views
0 votes
1 answer

How to create a global filter

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

answered Apr 13, 2018 in Tableau by QueenBee
• 1,820 points
407 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,550 points
474 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,230 points
358 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 21, 2018 in Tableau by Atul
• 10,230 points
3,674 views