Dax issue

[Anonymous]

Company ,    Product name
Tatamotors,        Tiago
Tatamotors ,       Alto
Tatamotors  ,     Nexo
Maruti ,              Ciaz
Maruti  ,            vagnour
Hundai  ,            I20
Hundai   ,          Creta

In above senario, Ihave to count total number of products by each company:

Below dax I have written but getting error as "The expression refrers to multiple column.Multiple columns can not be converted to a scalar value: Please suggest:

Groupby(Automobile,automobile[company],"Total number of Product", Countax(currentgroup(),automobile[product name]))

[v-yuta-msft · Accepted solution]

Hi Ashokkumarsah, 

GROUPBY() function return a table with the selected columns for the groupBy_columnName arguments and the grouped by columns designated by the name arguments. So you should create a new table, not a calculate column or measure.

Regards,

Jimmy Tao

[PattemManohar]

@Anonymous Not sure why itsn't working ? Hope you are trying it as a "New Table"

Test130Out = GROUPBY(Test130GroupCnt,Test130GroupCnt[Company],"ProductCount",COUNTAX(CURRENTGROUP(),Test130GroupCnt[ProductName]))