The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
8 | |
8 |