Calculate an expression based on a text within Pivot Table

[#1]

Hi Guys,

I want to know if the following is possible and if not, why

I have a pivot table with the following dimensions

1) Calendar Year

2) ExpressionOverview.MeasureNumber // A list of 42 numbers

The expression is as follows

1) Only(ExpressionOverview.Expression)

This gives me back the calculation used to populate that measure. If I take the above expression and do the following in a text object

=$(=Only(ExpressionOverview.Expression)) it calculates the value correctly. However, if I use the same expression in the expression tab in a pivot table it returns null for all my expressions.

Why is it not calculating? Is it possible to force this calculation with the above method

Your assistance in this regard is greatly appreciated

Cheers,

Byron

[#2]

Oh an important note, I know that the dimension measure number needs to be ignored when calculating. So for the actual expression I included a total qualifier. See below for example of before and after

Before - Count(DISTINCT {<Measure4IndicatorExit={'1'}>}DRNum)....

After - Count(TOTAL <CalendarYear> DISTINCT {<Measure4IndicatorExit={'1'}>}DRNum)....

I am probably doing this all wrong, but thats where you smart folks come in

Thanks,

Byron

[#3]

bump

[#4]

Absolutely last bump promise