DAX error

Question

Hi, I would like to get help with the following DAX:

I try to group number of customers by their deposit balance:

Customer groups = SUMMARIZE ( GROUPBY ( MonthsTrend, MonthsTrend[CUST.NO], "Total Balance", SUM (MonthsTrend[ LOC.BAL. ]) ), "Balance Group", SWITCH ( TRUE (), SUM (MonthsTrend[ LOC.BAL. ]) <= 1000, "0-1000", SUM (MonthsTrend[ LOC.BAL. ]) <= 10000, "1000-10000", "Over 10000" ), "Total Customers", COUNTROWS (VALUES (MonthsTrend[CUST.NO])) )

However, I receive the following error:

Function "Groupby" scalar expressions have to be aggregation functions over CurrentGroup()

What am I doing wrong?

Thanks in advance

freemanz · Accepted Answer

hi HarunK&nbsp;try like:Customer&nbsp;groups&nbsp;=&nbsp;SUMMARIZE (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GROUPBY (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MonthsTrend,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MonthsTrend[CUST.NO],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Total Balance",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUMX(CURRENTGROUP(),&nbsp;MonthsTrend[ LOC.BAL. ])&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;), &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Balance Group",&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;CALCULATE(SWITCH (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TRUE&nbsp;(),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM&nbsp;(MonthsTrend[ LOC.BAL. ])&nbsp;&lt;=&nbsp;1000, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"0-1000",&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM(MonthsTrend[LOC.BAL.])&nbsp;&lt;=&nbsp;10000,&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "1000-10000",&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Over 10000"&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; )),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Total Customers",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COUNTROWS(VALUES&nbsp;(MonthsTrend[CUST.NO]))&nbsp;)

Forum Discussion

DAX error

2 Replies

Related content

Dax error

Dax

error message

DAX

DAX Error SUMX