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

 

 

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