Where is the error )

[RGL]

I have this and I don't see a difference from the example in Microsoft docs

SUMMARIZE(Venta,

Calendario[SemanaCom],

Clientes[C CLIENTE],

Clientes[N CLIENTE],

"Venta",sum(Venta[Importe]))

I get this error:

The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

What should I change?

[camargos88 · Accepted solution]

@RGL ,

Unless you are creating a table, you are gonna get this error. 

Measures and calculated columns are scalar values. So, if it's the case your return has to be a single value.

[RGL]

@camargos88 

It has to be a table!!!

Thanks!

[Tahreem24]

Is this measure or calculated column or calculated table?

[parry2k]

@RGL did you set up the relationship between these tables? How does that looks like?

[RGL]

@parry2k  Yes, they are related by the [C Cliente] key and the [Date] key... I have other measures involving these that work...

[parry2k]

@RGL cannot say anything without looking at it, share sample pbix file.