Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 formula I used:
I got the outcome I required using other way as per below:
But I want to get it done using group by function why that is giving the error?
@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.
User | Count |
---|---|
91 | |
77 | |
71 | |
64 | |
58 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
61 |