title: USERELATIONSHIP in a measure with text column
body: <p>CONTEXT:</p>
  <p>I want to monitor payment transactions for money laundering, where payments cross multiple borders. There are a max of 6 countries shown per transaction. For each of these countries, I need to know a risk level.</p>
  <p>I have 2 tables:</p>
  <ol>
  <li><p>Transaction data (where there are many transactions from same country)</p>
  </li>
  <li><p>Country Risk (containing each country once, with an added risk classification. There are 100+ countries, and only 6 different Risk levels).</p>
  </li>
  </ol>
  <p>Problem:</p>
  <p>I would like to look up the Risk Classification per country in Transaction Data. The problem is, there are 6 countries per transaction in Transaction Data. So I have to link Transaction data to Country Risk 6 times. Only 1 relationship can be active, of course.</p>
  <p>So I tried writing the following measure:</p>
  <pre><code>CALCULATE(   
  VALUES('Country Risk'[Risk classification]);  
  USERELATIONSHIP('Transaction Data'[Country 2];'Country Risk'[Country Code]))
  </code></pre>
  <p>I get an error though when using the measure in a graph where I listed the countries from Transaction Data (where every country is mentioned in multiple rows) and I wanted to see the related risk categories:</p>
  <p><strong>A table of multiple values was supplied where a single value was expected</strong></p>
  <p>What am I doing wrong?</p>
  <p>Made similar test data: <a href="https://drive.google.com/file/d/1_kJW-BpbrwCsbSpxdo7AJ3IzPy2oLWFJ/view?usp=sharing" rel="nofollow noreferrer">https://drive.google.com/file/d/1_kJW-BpbrwCsbSpxdo7AJ3IzPy2oLWFJ/view?usp=sharing</a></p>
  <p><strong>Needed:</strong></p>
  <ol>
  <li><p>for every C (C1-C6) column I need to add the risk category.</p>
  </li>
  <li><p>For every C column I need to make a pie chart showing the number of transactions per risk category for that C column</p>
  </li>
  <li><p>Pie charts should filter the transaction oevrview: (</p>
  </li>
  </ol>