Power BI DAX error

[Eddie]

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 · Accepted solution]

@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.