Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

I'm trying to get the number of tickets per operator 

so i tried to use group by but it gives me this error every single time

Need Help
Tutorial Requests
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, Anonymous ;

    As mentioned , The GROUPBY function returns a table. So if grouping you can use the allexcept() function; Convert the above formula to the following format：

    Number =
CALCULATE (
    COUNT ( Dim_Operator[Operator_Key),allexcept(Dim_Operator,Dim_Operator[Operator1] )
)

     
    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    3 years ago

    A measure can only output a single value. The GROUPBY function returns a table.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    Hi, Anonymous ;

    As mentioned , The GROUPBY function returns a table. So if grouping you can use the allexcept() function; Convert the above formula to the following format：

    Number =
CALCULATE (
    COUNT ( Dim_Operator[Operator_Key),allexcept(Dim_Operator,Dim_Operator[Operator1] )
)

     
    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Related content