Hi,

We are using following code for measure:

MEMBER [Measures].[FID] AS

Head(

NonEmpty(

EXISTING [Time].[Fiscal Hierarchy].[FiscalMonth].Members,

([Measures].[Sales Quantity])

),

1

).Item(0).properties("key", TYPED)

MEMBER [Measures].[First Invoice Date]AS

MIN(NonEmpty(

(

{[Brand].[Brand].currentmember} *

{[Customer].[Country].currentmember}*

{[Currency].[Currency].[Currency]}

),[Measures].[FID]),

[Measures].[FID])

Note:- In [Measures].[FID] it shows the different Invoice Month for diffrenet currencies irrespective of same brand and country so user requested to get min of FID so created 2nd [Measures].[First Invoice Date].

Regards,

Amit