I have a tableau data grid that I need to count distinct records. If the status is Complete distinct count the RecordID
IF [Status] = "COMPLETE" THEN COUNTD([Survey ID]) ELSE 0 END)
But I am getting an error "Cannot mix aggregate and non-aggregate comparisons or results in IF expression". Any ideas?