Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
98 | |
63 | |
45 | |
36 | |
35 |