title: SQL Scalar Function values into power bi table
body: <p>I have two SQL functions in Power BI</p>
  
  <p><a href="https://i.stack.imgur.com/z37ZA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/z37ZA.png" alt="SQL Scalar-Valued Function in Power Bi"></a></p>
  
  <p>Each returns one number each (say fn_1 =3 fn_2 = 4). What I am trying to do is create a table that has 2 column 1 row with fn_1 as a colum and fn_2 as the 2nd column</p>
  
  <pre><code>|---------------------|------------------|
  |        fn_1         |       fn_2       |
  |---------------------|------------------|
  |          3          |          4       |
  |---------------------|------------------|
  </code></pre>
  
  <p>Tried duplicate, combine, aggregate, merge. They're all returning something different. </p>
  
  <p>Thanks</p>
  
  <p>EDIT: The only reason wanting to do that is so I can combine them into 1 row as 3/4 (which I can do fine with regular table) have both values (3 and 4 as 3/4) display on top of a report as 3/4 using a card.</p>