Distinct Count - can I have empty/null default to Zero

I have some Distinct Counts in a Multidimensional Cube, and Cannot seem to be able to create another calculated column from the Distinct Count and make zero is no rows exist for that Distinct Count.

Thomas

March 20th, 2015 5:15pm

You could put a test in the calculated member. Or an even easier way to ensure a zero is returned is to add zero to your measure (SSAS treats a null as mathematically zero). eg

Measures.MyDistinctCount as Measures.RawDistinctCount+0

Hope that helps,

Free Windows Admin Tool Kit Click here and download it now
March 22nd, 2015 7:50pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics