Forum Discussion

HarunK's avatar
HarunK
Regular Visitor
3 years ago
Solved

DAX error

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], "T...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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])) 
    )
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

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])) 
)
  • HarunK's avatar
    HarunK
    Regular Visitor
    3 years ago

    Thank you very much FreemanZ!