Trouble With Calculated Member

Say I have the following query, below

SELECT [Measures].[Sales Amount] ON 0,
[Product].[Category].[Category] ON 1
FROM [Adventure Works]
WHERE {[Date].[Calendar].[Month].&[2003]&[1] : [Date].[Calendar].[Month].&[2003]&[3]}

How can I add a calculated member that shows the MIN date for each Product Category that Actual had [Sales Amount] value, while keeping the [Sales Amount] total in the 0 Axis for all the dates in the slicer?

Thanks!

I have a product dimension table whose level is category-brand-product id. I have a fact table at lowest level product id and measure sales amt which can have positive and negative values.

I need distinct count  of brands for a particular category whose sales is greater than 0.

fact table data:                                   product table
productid salesamt                              category brand   productid
1             50                                          c1         b1         1
2             100                &nb

Someone posted an interview question here: http://www.ssas-info.com/analysis-services-implementations/69-experience/1352-dave-rodabaughs-analysis-services-interview-questions

“Where would you put a calculated member if you wanted it to intersect all other dimensions?”

What does he mean by "intersect" here? Any examples?

I would like to add a calculated measure to my cube which is only scoped for the desendants of a specific dimension member.  For all other members of that dimension it would return a zero or null value.

I believe it is similar to the code below, however, rather than having the dimension reference in the where clasue "WHERE [Product].[Category].[Bikes]", it would be part of the MEMBER. 

Something like:

   MEMBER [Measures].[Special Discount] AS
   iif([Product].[Category].CurrentMember,  [Product].[Category].[Bikes].children, ( [Measures].[Discount Amount] * 1.5),  0)

Example from MSDN:

WITH
   MEMBER [Measures].[Special Discount] AS
   [Measures].[Discount Amount] * 1.5
SELECT
   [Measures].[Special Discount] on COLUMNS,
   NON EMPTY [Product].[Product].MEMBERS  ON Rows
FROM [Adventure Works]
WHERE [Product].[Category].[Bikes]

HI ALL:

Example:

Region and Year are dimensions. Count is a measure value. I want to create a calculated member as Historical.

Region       Year           Month               Count              Historical

AMS           2010            1                      4                        4

AMS           2010            2                      3                        7  (4+3)

AMS           2010     &nb

I have a Calculated Measure that was inherited. The logic is:

STRTOMEMBER(

"[Time].[Time Hierarchy].[Month].&["

CurrentMember.Properties("Key0")) )

+ "]&["

CurrentMember.Member_key))

+ "]"

),[Measures].[Regular Cases])

If the [ForecastMonth].[Forecast Month].[Month] is assigned