Hi i have same problem with little different requirement, following is my query
select NON EMPTY{
[Measures].[Clicks],
[Measures].[YAP Delivered Impressions],
[Measures].[YAP Scheduled Impressions],
[Measures].[Total Measured Revenue Constant]} on columns,
NON Empty (FILTER(
[Order].[Order Number].[Order Number],
[Measures].[Clicks] > 0...