title: PowerBi Lookupvalue fucntion has stopped working
body: <p>I have a Power Bi report which uses the lookupvalue function which has been working fine and now it comes back with the error code of</p>
  <p><em>A table of multiple values was supplied where a single value was expected.</em></p>
  <p>my code</p>
  <p><code>LOOKUPVALUE('Nil Stock'[NilTotal],'Nil Stock'[AsOfDate],'Failed Orders'[VisitDate],'Nil Stock'[ClientDesc],'Failed Orders'[ClientDesc])</code></p>
  <p>Can anyone figure out why it's stopped working</p>