Distinct Count of an IF Statement is One Higher than Expected
Published: 10 May 2017
Last Modified Date: 14 Oct 2019
IssueWhen calculating COUNTD() of another calculation that is an IF statement with an ELSE "" clause, then the counts are one higher than expected
IF [Region] = "Central"
THEN [Customer Name]
ResolutionReplace ELSE "" with ELSE NULL.
CauseAn empty string, written as "", is a distinct text value that will be counted.