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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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)
User | Count |
---|---|
10 | |
8 | |
5 | |
5 | |
4 |