Forum Discussion

gumis_rulez's avatar
gumis_rulez
Icon for Helper I rankHelper I
2 years ago
Solved

Creating Summarize and referencing it in the same function to sum up values

Hi, I am trying to make a summarize table (summarizing customers number of orders and total value of those orders) and then would like to refer to it in SUM function to sum sales only those customer...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    Please try something like below whether it suits your requirement.

     

    NewCustomersSales =
VAR CustomerOrders =
    SUMMARIZE (
        Orders,
        Orders[CompanyName],
        "OrdersCount", CALCULATE ( DISTINCTCOUNT ( Orders[OrderID] ) ),
        "TotalSales", CALCULATE ( SUM ( Orders[Sales] ) )
    )
RETURN
    SUMX ( FILTER ( CustomerOrders, [OrdersCount] <= 3 ), [TotalSales] )
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

Hi,

Please try something like below whether it suits your requirement.

 

NewCustomersSales =
VAR CustomerOrders =
    SUMMARIZE (
        Orders,
        Orders[CompanyName],
        "OrdersCount", CALCULATE ( DISTINCTCOUNT ( Orders[OrderID] ) ),
        "TotalSales", CALCULATE ( SUM ( Orders[Sales] ) )
    )
RETURN
    SUMX ( FILTER ( CustomerOrders, [OrdersCount] <= 3 ), [TotalSales] )