I have a measure named "Person Count". I am trying to make a calculated measure that gives me the same result if i made a dataset and had "Person Count" filtered by [Crash][Is injury]&[yes] (which is under the Crash dimension. How would i write the query in mdx for the calculated measure. This is what i thought it should be:
[Measures].[Person Count] * [Crash].[Is Fatal Injury].&[Yes]
Where did i go wrong? I get nulls in the field. I did this before for another calculated member with a colegue, but i cant seem to remember exactly how it was written. And i cant get into his computer. Please help, i know its something little.
Figure out it needed a comma! which i tried before, but didnt use parenthesis!
here's the answer for future references!
( [Measures].[Person Count] , [Crash].[Is Fatal Injury].&[Yes] )
No comments:
Post a Comment