Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago
Solved

Min give error due to blank or empty value

Hello, I have follow measure, that works well with most part of values, but it shows error in some cases. if(values(Mastermaterialsap[DChain-spec.])="E51",Measurement[Total months availa...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    3 years ago

    Finally if it has worked. Thanks a lot

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Hello the data type is the same. It happens that with most row elements it represents the value well. It only gives error in some elements and that is why when all the elements are selected it gives this error

Error Message:
MdxScript(Model) (711, 6) Calculation error in measurement 'Measures'[Semaphore 5monthsATW/CM]: A table of several values was provided where a single value was expected.

and I get the feeling that it gives conflict in the values that do not have data in some months, and therefore the MIN does not calculate well.

Thank you

sonia