Conditional Measure Expression

[marcoyukon]

Is it possible to switch to another expression based on a variable value ?

Example

Measure Expression P_COUNT:

= IF (v_IsClosed = "Yes")       

     COUNT( { $< [P.Type]=, DateType= { 'Closed' }> } P_Id )  

ELSE       

     COUNT( { $< [DateType]={ 'Ref' }> } P_Id )

..Is there a workable solution to this ?

[sunny_talwar · Accepted solution]

May be this

If(v_IsClosed = 'Yes', Count({$<[P.Type], DateType = {'Closed'}>} P_Id), Count({$<[DateType] = {'Ref'}>} P_Id)

[marcoyukon]

Yes, thanks.

[sunny_talwar]

Please close the thread if you got what you wanted.

Best,

Sunny