Forum Discussion
Not able to get the group by function correct
I am trying to get the average value if different groups. But getting error as 'The expression contains multiple columns. Multiple columns cannot be converted to scalar value.' Below is the formu...
kishanthacker GROUPBY returns a table of values, not a single value so you need to use an aggregation like perhaps:
AVERAGEX( <your groupby code>, [Avg sales])
No that won't solve the problem. I tried around creating table measure or calculated table I am unsure what to call it (The symbol is combination of table and measure).
The snap shot is enclosed.