topic Re: DAX error in DAX Commands and Tips

DAX error

HarunK — Tue, 04 Apr 2023 21:51:35 GMT

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

Re: DAX error

FreemanZ — Tue, 04 Apr 2023 22:41:02 GMT

hi HarunK

try like:

Customer groups =

SUMMARIZE (

GROUPBY (

MonthsTrend,

MonthsTrend[CUST.NO],

"Total Balance",

SUMX(CURRENTGROUP(), MonthsTrend[ LOC.BAL. ])

"Balance Group",

CALCULATE(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]))

)

Re: DAX error

HarunK — Wed, 05 Apr 2023 01:46:04 GMT

Thank you very much FreemanZ!