Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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]))
Solved! Go to 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
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
@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]))
Proud to be a PBI Community Champion
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |