InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 03:48:33 GMT20http://www.sqlservercentral.com/Forums/Topic899336-17-1.aspxHello 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,CeesThu, 22 Apr 2010 05:17:34 GMTcees van diermenhttp://www.sqlservercentral.com/Forums/Topic899336-17-1.aspxDear 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 appreciatedRegardsDemiThu, 08 Apr 2010 01:55:30 GMTdemitri_baran