You can use the HAVING function
SELECT NON EMPTY { [Measures].[Net Revenue] } ON COLUMNS ,
NON EMPTY { DESCENDANTS( [Date].[Date Hierarchy].[Year].&[2012], [Date].[Date Hierarchy].[Month] ) }
HAVING [Measures].[Net Revenue] > 100000
ON ROWS
FROM [CUBE]
Mack