

SELECT 
NON EMPTY {Hierarchize({[Time.defaultHiera].[All Time]})} on columns,
NON EMPTY {Hierarchize(Crossjoin(Union([Customers.defaultHiera].[All Customers].[France].children, {[Customers.defaultHiera].[All Customers].[France]}, {[Customers.defaultHiera].[All Customers]}), {[Measures].[Quantity]}))} on rows
FROM [Sales Analysis]
WHERE ([Customers.defaultHiera].[All Customers].[France])
