Forum Discussion

Eddie's avatar
Eddie
New Member
9 years ago
Solved

Power BI DAX error

I created a mesasure using import mode and was able to use it in a vizualization. However, when I use the same measure in direct query mode, I get the following error: " MdxScript(Model) (1,169) calculation error in measure "Measure table[Measure Name]: A table of multiple values was supplied where a single value was expected.

 

Again I created the same value in import mode and did not get this error. Any suggestions on how to fix this?

 

Thanks,

 

 

  • ankitpatira's avatar
    ankitpatira
    9 years ago

    Eddie I've seen this error happening also on directquery mode but works fine when published to service (so just ignore it in poewr bi desktop). Just make sure under File -> Options and settings -> Options -> Directquery -> you have allow unrestricted measures in directquery mode ticked. 

1 Reply

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    9 years ago

    Eddie I've seen this error happening also on directquery mode but works fine when published to service (so just ignore it in poewr bi desktop). Just make sure under File -> Options and settings -> Options -> Directquery -> you have allow unrestricted measures in directquery mode ticked.