'How to check if dimension value is available on all days in tableau

I have two input dimensions i.e. Day and Product_sold and I want to create a calculated field "Flag" in Tableau. Basically Flag will show "Yes" if the product was sold on all days, else No (see example attached), can you please help? I have tried multiple things but no use

enter image description here

tableau-desktop


Solution 1:[1]

You can create a fixed LoD calculation to count distinct number of days in data. Then used another fixed LoD (or possibly a table calc) to count distinct days for each product. If the product COUNTD = dataset COUNTD than it sold on every day.

Solution 2:[2]

What have you tried so far? This looks like a simple attribution calc that could be put together as boolean eg:

Product_sold = 'computer'

Steve

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 James Emery
Solution 2 Steve Martin

Related Questions