Count distinct ignore nulls in Pivot

[sravala]

Hi,

In a Pivot fact column I need to count(distinct) of a column, but I want to ignore the null values, how can I do that.

Thank you in adavance.
Syamala.

 

[stacybost]

Here's something to try:

if (CountNull (Column_name) > 0)
{CountDistinct (Column_name) - 1 }
else
{CountDistinct(Column_name) }