Distinct Count Cube Measures

Hi Guys,

You have this great article, https://support.timextender.com/hc/en-us/articles/210438723-How-to-handle-that-DistinctCount-counts-NULL-values, on how to ignore NULL values in distinct counts.

Why not implement this in the measure itself by fx. having a tick mark "Exclude NULLs". If this is ticked, simply set a filter on the partition of the distinct count measure: MyField IS NOT NULL



Please sign in to leave a comment.