Forum Discussion
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...
Thank you that worked,
If you have the time and patience, would it be possible to explain why. I guess it has something to do with the Table "Targets" but can't figure out the reason for the error. thanks again.
- tamerj1
Community Champion
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)
Thank you for explaining, it now makes sense. I am still pretty green with Power BI so getting an explanation really helps.