How to recalculate measure based on filtered values

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

Back to top

- Similar topics

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