WITH 
MEMBER [Customer].[Gender].[20] as null
MEMBER [Customer].[Gender].[50] as null
MEMBER [Customer].[Gender].[100] as null
MEMBER [Customer].[Gender].[200] as null
MEMBER [val_min] as case 
                                     when [Customer].[Gender].CurrentMember is [Customer].[Gender].[20] then 0
                                     when [Customer].[Gender].CurrentMember is [Customer].[Gender].[50] then 21
                                     when [Customer].[Gender].CurrentMember is [Customer].[Gender].[100] then 51
                                     when [Customer].[Gender].CurrentMember is [Customer].[Gender].[200] then 101
                                    end
MEMBER [val_max] as case 
                                     when [Customer].[Gender].CurrentMember is [Customer].[Gender].[20] then 20
                                     when [Customer].[Gender].CurrentMember is [Customer].[Gender].[50] then 50
                                     when [Customer].[Gender].CurrentMember is [Customer].[Gender].[100] then 100
                                     when [Customer].[Gender].CurrentMember is [Customer].[Gender].[200] then 200
                                    end

set [CC] as {[Customer].[Gender].[20], [Customer].[Gender].[50], [Customer].[Gender].[100], [Customer].[Gender].[200]}

member [gen] as 
  generate(
    filter(
      exists([Customer].[City].[City], [Customer].[Country].CurrentMember), 
      ([Customer].[Gender].[All],[Measures].[Customer Count]) > ([Customer].[Gender].CurrentMember, [val_min]) 
        and 
     ([Customer].[Gender].[All], [Measures].[Customer Count]) <= ([Customer].[Gender].CurrentMember, [val_max])
    ), 
   [Customer].[City].CurrentMember.Name +  ', ')

 SELECT  
  { [val_min], [val_max], [gen]} ON COLUMNS,
  {[Customer].[Country].[Country] * [CC]} ON ROWS
 FROM 
  [Adventure Works]