Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
I'm trying to use Summarize for the first time, and i keep getting an error that says
Semantic error: "multiple values cannot be converted to a scalar value"
This is my DAX
And below is the tables I'm working with
Any ideas what could be wrong ? Thanks
What result are you expecting from the countx? If you want the count by [case type] you need to add that as a column first, then your summary could be simply "count", countrows(new inventory)
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 33 | |
| 31 | |
| 19 | |
| 12 | |
| 10 |