Forum Discussion

TJCappy's avatar
TJCappy
Frequent Visitor
3 years ago
Solved

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

Hi All,   Based on the sales for a given period, I am trying to calclate the number of clients a sales rep will need to have to attain their sales goal.   I have the following data and can't seem...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi TJCappy 

    please try

    Clients Needed for Target =
    SUMX (
    'Targets',
    DIVIDE (
    'Targets'[2023 Annual Target],
    [CNM Distinct Client Gross sales Average]
    )
    )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

TJCappy 

The first argument of CALCULATE has to be sn expression that yields a scalar value but you have specified a table ('Targets').  The second argument of CALCULATE if a Filter expression (in other words a table)

TJCappy's avatar
TJCappy
Frequent Visitor
3 years ago

Thank you for explaining, it now makes sense. I am still pretty green with Power BI so getting an explanation really helps.

Related content