Calculated Measure Result is Based in Dimension Picked

  • 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

    Regards

    Demi

  • 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

    regards,

    Cees

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply