Forum Discussion
Error MdxScript(Model) (196,47)
You should check your computed columns, the current error occurs when multiple values are passed to the computed column. Make sure that each expression used in the computed column returns a unique value.
If you refresh the data source and multiple values are returned in the new data according to your previous calculation logic, the current error will also occur.
hackcrr
If I have answered your question, please mark my reply as solution and kudos to this post, thank you!
Consequently I am trying to comment all the measures to see when the file refreshes and identify the faulty one. This is a tediuos and time-consuming process, since I have lots of measures using the functions you mentioned, but seems the only way right now
Does this error measures describe a faulty DAX only ? Or can that error message correspond to other areas like M code or model relationships ?
You should check your computed columns, the current error occurs when multiple values are passed to the computed column. Make sure that each expression used in the computed column returns a unique value.
If you refresh the data source and multiple values are returned in the new data according to your previous calculation logic, the current error will also occur.
hackcrr
If I have answered your question, please mark my reply as solution and kudos to this post, thank you!