How to recalculate measure based on filtered values

View previous topic View next topic Go down

How to recalculate measure based on filtered values

Post  komaty on Tue May 07, 2013 12:26 am


Hi all,

I am a newbie in SSAS, I have encountered a minor issues in cube and I cant solve it in many days
Please help me this, I very appreciate your ideas.

My cube has a measure that shows the percentage.
The percentage does not displays correctly when we use filter. For example:
Without filter any dimensions, it is correct
Age Percentage
15 - 24 11.64%
25 - 24 24.21%
35 - 44 24.03%
45 - 54 20.17%
55 - 64 12.92%
65+ 6.66%
Do not know 0.38%
Grand Total 100.00%

With filter Gender=Male (or any dimensions), it likes this.
Age Percentage
15 - 24 4.72%
25 - 24 13.55%
35 - 44 15.87%
45 - 54 13.52%
55 - 64 8.07%
65+ 3.66%
Do not know 0.18%
Grand Total 59.58%

what I expect that it should be 100% in Grand Total and the percentage of each category must be recalculated.


komaty

Posts : 7
Join date : 2013-01-11

View user profile

Back to top Go down

Re: How to recalculate measure based on filtered values

Post  Mike Honey on Tue May 07, 2013 11:22 pm

Hi komaty

You havent posted your Measure definition so I dont know how you expect anyone to help you.

In any case I would try to resolve this using the client tool e.g. in Excel you can direct it to Show Values as: % of Column Total. This would be based on the underlying measure value and remove the need for complex MDX.

Good luck!
Mike
avatar
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

View user profile http://www.mangasolutions.com

Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum