Don't Count Distinct Null

• demitri_baran

  SSC-Addicted

  Points: 423

  More actions

  October 28, 2009 at 9:42 am

  #136896

  My measure group contains only a single measure that applies a distinct count aggregation, that also counts null as 1. Is there a way to not count the null records.

  eg. Country Desc

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  October 28, 2009 at 10:16 am

  #1071886

  Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic810071-17-1.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• aedna-843346

  SSC Enthusiast

  Points: 177

  More actions

  November 29, 2011 at 11:18 am

  #1414264

  I had the same problem. I solved it by creating a view with a WHERE condition ISNULL(ID,0) <> 0 and then creating a Distinct Count out of this view