Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Calculated Measure Result is Based in Dimension Picked Rate Topic Display Mode Topic Options
Author
 Message
 Posted Thursday, April 8, 2010 1:55 AM
 Grasshopper 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 DaysJohn Smith A 10John Smith B 10 John Smith C 10The requirement is to created a "calculated measure" based on Earned Days...Its called Exposed Population = Earned Days / 365The 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 MDXHelp is kindly appreciatedRegardsDemi
Post #899336
 Posted Thursday, April 22, 2010 5:17 AM
 Valued 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 measureregards,Cees
Post #908470

 Permissions