-
Don't COUNT my zeroes.
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|