MDX script error-Value() function error

[Anonymous]

Hi All,

I am trying to create a measure where trying to compare the year .

here PersonsYrValue = VALUES(table[Year]) where  year is base column of the table.

while using the base column"year" in a measure I am getting below error.

I also tried using FIRSTNONBLANK value function,but its not working.

Any suggestion would be appreciated.

[v-xulin-mstf]

Hi @Anonymous,

The error message shows that the measure return multiple values.

Could you provide details about the measure?

Best Regards,

Link

[amitchandak · Accepted solution]

@Anonymous , if this a measure you need have

Max(table[Year])

or try [PersonsYrValue] in {2020}