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 ffdfd
• 5,550 points
790 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

Adding new filter to an existing dashboard on Tableau

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

answered Apr 5, 2022 in Tableau by Neha
• 9,060 points
5,003 views
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
16,976 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,240 points
1,900 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 ffdfd
• 5,550 points
2,133 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,030 points
366 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
3,716 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
1,197 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 ffdfd
• 5,550 points
881 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
1,195 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,240 points
4,752 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP