Expression

[PIAnalytical]

Hello,

I have an expression that works on my KPI but does not work when I make a variable.  My objective is to show the sum for the maximum date as a KPI. 

=Sum({<[Month-Year]={"$(=Max([Month-Year]]))"}>}VALUE)

[GaryGiles]

How are you defining the variable?  Can you show an example?

[PIAnalytical]

SET eCurrent =Sum({<Month-Year={"$(=Max(Month-Year))"}>}VALUE);

[GaryGiles]

I believe the $-expansion is taking place at the time you are defining the variable.  Try this instead:

Let eCurrent = 'Sum({<Month-Year={"$'&'(=Max(Month-Year))"}>}VALUE)';

This way, the $-expansion will occur when you use the variable in a measure expression $(eCurrent).

[PIAnalytical]

No Luck. For the life of me I cannot figure out what the issue is