Variable in Expression

[RutiTaumanRubin]

Hi,

I defined measure with variable but it seems like the measure ignore from the variable.

Measure:

count({<ACTION_TYPE={"OPENED"}, 1={ '$( =$(V_CommDate_LastMonth) )' }>} Distinct ISSUE_ID)

Variable:

SET V_CommDate_LastMonth="if(GetSelectedCount(CommDate)>0 or GetSelectedCount(CommDateYear)>0 or GetSelectedCount(CommDateQuarter)>0 or GetSelectedCount(CommDateMonth)>0 or GetSelectedCount(COMM_DATE)>0,
IF(DATE(CommDate)=Date(CommDate),1,0),
IF(Date(CommDate)>makedate(Year(AddMonths(Max(All {$} CommDate),-1)),Month(AddMonths(Max(All {$} CommDate),-1)),day(MonthEnd(AddMonths(Max(All {$} CommDate),-1)))),1,0))";

Any Idea?

Thanks!