Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Where is the error )

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?
 
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Anonymous ,

     

    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.

6 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        6 years ago

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

  • camargos88's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous ,

     

    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.