Calculated measure based on dimension selection - PMPM calculation

[ejsmith]

I am trying to use a calculated measure which has a different formula depending upon whether or not certain dimensions have been used to limit the results.

I am trying to get a Per Member Per Month (PMPM) figure in a healthcare environment... normally not the hardest thing to do - except in our situation we need to use different denominators depending upon which dimension is used to limit the data. For Example say we have two dimensions (Category of Service, AsthmaFlag). If we are looking at the PMPM for Category of service the formula is ( Paid $ / 1,000,000 ) but if it is limited by the AsthmaFlag dimension the formula would be ( Paid $ / 3,456 ). The denominators are fictional... Someone in the healthcare industry must have come across this before... any help would be greatly appreciated!

 

[Flybridge]

I don't understand the problem. If you create the formula as a calculated member it will automatically detect where you are in the cube and return the value for the members you have sliced and diced to.

Or have I misse the point.

 

[johnherman]

If I understand the problem correctly, someone created a set of denominators based on the prevalence of conditions (such as asthma, diabetes, hypertension, etc) per million, so that's why asthma has a denominator of 3456.

Is this a correct interpretation of the problem?

-------------------------
The reasonable man adapts himself to the world. The unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. - George Bernard Shaw

 

[ejsmith]

Flybridge & johnherman, yes - so the denominator changes depending upon what the dimension is. I think I've solved it - I'm using the ValidMeasure() function on the calculated field - and so far it seems to be working great.
Now all I have to do is figure out a way to turn virtual cube into a local cube!
Thanks for your help!