-- Code snippet of the day ( March 27th , 2017 )

-- Use NON EMPTY To exclude customers with out orders
-- from Bike Category which we specified in WHERE
-- Condition

SELECT
	[Measures].[Internet Order Count] ON COLUMNS,
	NON EMPTY ([Customer].[Customer].Children) ON ROWS
FROM [Adventure Works]
WHERE [Product].[Product Categories].[Category].[Bikes]