Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Calculated Measure Result is Based in Dimension Picked Expand / Collapse
Posted Thursday, April 8, 2010 1:55 AM


Group: General Forum Members
Last Login: Tuesday, September 21, 2010 5:34 AM
Points: 11, Visits: 117
Dear All,

I have the following Case ... In the Fact:

Person Name Plan ID Earned Days
John Smith A 10
John Smith B 10
John Smith C 10

The requirement is to created a "calculated measure" based on Earned Days...
Its called Exposed Population = Earned Days / 365

The result of this measure is based on the dimension picked

if Dimension is Person then Exposed Population = 10 / 365
(Noticed that 10 is picked only once)

If Dimension is Plan then Exposed Population = (10+10+10) / 365
(Noticed that 10 is picked 3 times)

I would like to have a single calculated measure that deals with this ... I am a bit naive in MDX

Help is kindly appreciated


Post #899336
Posted Thursday, April 22, 2010 5:17 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, September 3, 2010 5:15 AM
Points: 57, Visits: 83
Hello Dimitri,

Can you provide more details.

John Smith has 30 Earned Days in total (Right ?),

I would expect that if I select John Smith in the Dimension Person I would get 30 and when I select a specific Plan, lets say A, i would get 10. However that's not what I get from your post.

What are the outcomes you want to see ? It would be helpfull if you post the calculated measure


Post #908470
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse