Forum Discussion

rjsidek's avatar
rjsidek
Icon for Helper II rankHelper II
6 years ago

Lookupvalue error = A table of multiple values was supplied when a single value was expected

Hello,   I currently have a dataset that looks like this     I created a measure in powerbi with the following DAX     Status of Deal Current Status = VAR __selectedDate = MAX ( Table...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

What is the error.  When i open the file, take the measure away from the visual and reinsert it, it shows the results just fine.

 

  • rjsidek's avatar
    rjsidek
    Icon for Helper II rankHelper II
    6 years ago

    Hi Ashish,

     

    I added a new entry for Jaya Grocer after the fact. If you try and refresh the dataset, PowerBI will not let you. It returns the following error:

     

    Failed to save modifications to the server. Error returned: 'MdxScript(Model) (7, 34) A table of multiple values was supplied where a single value was expected. The current operation was cancelled because another operation in the transaction failed. '.

     

    The error is not captured yet in the measure I created as Table1 is not refreshed to include the new entry for Jaya Grocer. Sorry for not clarifying this earlier