title: Using SELECTEDVALUE with PowerPivot
body: <p>I got help to the code below to create a measure in PowerPivot, but I'm running into errors because of <code>SELECTEDVALUE</code> which does not seem like a command I can use in Excel, anyone can help me around with this?</p>
  
  <pre><code>VAR SignUpMonth =
      SELECTEDVALUE ( Table1[Signup month] )
  VAR MonthDiff =
      SELECTEDVALUE ( '1 through 24'[Value] )
  RETURN
      DIVIDE (
          CALCULATE (
              SUM ( [conversion to KYC completed] ),
              FILTER ( Table1, Table1[Month Diff] = MonthDiff )
          ),
          CALCULATE (
              SUM ( Table1[ signups] ),
              FILTER ( ALL ( Table1 ), Table1[Signup month] = SignUpMonth )
          ),
          BLANK ()
      )
  </code></pre>