## Calculated Measure Result is Based in Dimension Picked

 Author Message demitri_baran Grasshopper Group: General Forum Members 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 cees van diermen Valued Member Group: General Forum Members Points: 65 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