Forum Discussion

pfarahani's avatar
pfarahani
Icon for Helper II rankHelper II
5 years ago

SUMMARIZE

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

1 Reply

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion
    5 years ago

    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)