1 of 1 people found this helpful
Can you change your formula to something more simple, perhaps this will do it?
COUNTD(if [Product] = "eggs" AND [type] = 'white' then [Contacts] end)
Or even just this:
if [Product] = "eggs" AND [type] = 'white' then [Contacts] end
and set it to Count Distinct when dragged to the worksheet?
3 of 3 people found this helpful
if ATTR([Product]) = "eggs" AND ATTR( [type] ) = 'white' then [Count] end
Since COUNT is an aggregate, everything in the calc has to be an aggregate. And ATTR is how you get a non-aggregate to look like an aggregate to Tableau.
Or what Andrew did.