A table of multiple values was supplied where a single value was expected

[godtooro]

Dear all,

Trust you are doing well.

I've this problem:

• _Measure [LCV Currency]: "A table of multiple values was supplied where a single value was expected"

The formula of the calculation is the next one:

And LCV Currency is calculated as follows:

On the contrary if for example I select as filter a distributor I don´t obtain the error.

Do you know how can I avoid the error?

[godtooro]

Help please???

[johnyip]

Because [LCV Currency] returns a column of multiple row. A table cannot display multiple row in a single "cell".

Since you don't have the sample data here, along with your desired table outcomes, there can be no suggestions to be given.

[godtooro]

Hi @johnyip !

Thank you for your support!

Here you are: Model_4