I have a measure named MeasureA which has and abundance of zeroes in the column, originally derived from the table creation and data insert Casexxx Whenxxx Else 0 when the table was built.

Well now they are in the way because they give false information on my measure when a count is performed. With the zeroes I receive 340,000 on my count. When zeroes are eliminated then my count is only 15,846.

Is there someway I can >0 or other MDX approach on the measure in the cube to prevent this problem. Or please provide a direction on this concern. Thanks for responses.