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
A table of multiple values was supplied where a single value was expected.
my code
LOOKUPVALUE('Nil Stock'[NilTotal],'Nil Stock'[AsOfDate],'Failed Orders'[VisitDate],'Nil Stock'[ClientDesc],'Failed Orders'[ClientDesc])
Can anyone figure out why it's stopped working