Minor issue using measure names in other measures.

[smurfier]

Just a little something I've noticed. If you want to use a measure name in another measure without dynamic variables, the original measure name cannot contain a period.

Example:

Code: Select all

[My.Measure]
Measure=Calc
Formula=1

[OtherMeasure]
Measure=Calc
Formula=My.Measure

This is invalid and would only work by using DynamicVariables. Remove the period and everything works just fine.

[dragonmage]

Have you tried this in measures other than CALC? I'm wondering if maybe CALC sees it as a decimal and gets confused.

[smurfier]

I have not tried that. I was also thinking about the calc measure seeing it as a decimal. Thing is that I was under the understanding that all other measures would require dynamic variables.

[dragonmage]

Have you tried dynamic variables and using the measurename inside []?

[poiru]

Have you tried dynamic variables and using the measurename inside []?

Read his post

[dragonmage]

Read his post

I did, I was just looking for a workaround for his calcs that did not require changing all his measure names or waiting for a fix.

[poiru]

I did, I was just looking for a workaround for his calcs that did not require changing all his measure names or waiting for a fix.

I know, I just thought you missed the part where he says that DynamicVariables work.

[smurfier]

I did end up removing the decimals in the measure names so that I don't have to use dynamic variables.

[jsmorley]

Sometimes the best way to make it stop hurting is to stop what you are doing that hurts.

[smurfier]

Well, if you want to go with the most obvious solution...