title: Count distinct IP addresses per country
body: <p>I have a cube with information about visits to a website with IP addresses and country.</p>
  
  <p>I'd like to retrieve the count of unique IP addresses per country, as in the following tabel.</p>
  
  <pre><code>+-------------+----------+
  | country     | count IP |
  +-------------+----------+
  | germany     | 2        |
  | netherlands | 3        |
  +-------------+----------+
  </code></pre>
  
  <p>But all I came up with so far is this:</p>
  
  <pre><code>+-------------+---------------+--------+
  | country     | IP            | visits |
  +-------------+---------------+--------+
  | germany     | 65.49.14.152  | 5      |
  |             | 66.55.144.187 | 12     |
  | netherlands | 93.114.46.11  | 2      |
  |             | 93.115.94.85  | 5      |
  |             | 141.105.1.7   | 1      |
  +-------------+---------------+--------+
  </code></pre>
  
  <p>which is produced by this query:</p>
  
  <pre><code>SELECT 
    NON EMPTY 
      {Hierarchize({[Measures].[Visits]})} ON COLUMNS
   ,NON EMPTY 
      CrossJoin
      (
        [Geografy.Localizacion].[Country].MEMBERS
       ,[RemoteClient].[IP].MEMBERS
      ) ON ROWS
  FROM [VisitsCube];
  </code></pre>
  
  <p>How can I modify this query to produce the results as in the first tabel?</p>