I'm trying to create a Calculated Field that gives me a distinct count of values in column A (Calculation1), when column B (ISCURRENT) is equal to 1.
It would be something like this:
TOTAL(COUNTD([Calculation1])) WHERE [ISCURRENT]=1
But obviously that won't work. It's a single calculation in a dashboard, and would get modified based on a slider filter.
Any help would be appreciated.
What about this:
COUNTD(IF IsCurrent = 1 THEN [Column A] ELSE NULL END)
That worked perfectly, thanks!
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...