Summarize twice

[dgdgdg122db]

Hello there, 

I want to first group my customers by customer ID,  the number of orders, and the date  (my TABLE 1)

then group again by customer ID and Orders ( Table 2 )

the goal is to find out how many customer ordered more than once ( excluding the orders purchased on the same day)

is it possible to write this in one dax formula?

Thank you 

TABLE1 = SUMMARIZE(Orders,Orders[Document Date],Orders[CustomerID],"Occurrence",DISTINCTCOUNT(Orders[Sales document]))

Table 2 = SUMMARIZE(TABLE1,TABLE1[CustomerID],"Occurrence2",COUNT(TABLE1[CustomerID]))

[VahidDM]

Hi @dgdgdg122db 

Try this:

TABLE1 =
VAR _A =
    SUMMARIZE(
        Orders,
        Orders[Document Date],
        Orders[CustomerID],
        "Occurrence", DISTINCTCOUNT( Orders[Sales document] )
    )
RETURN
    SUMMARIZE( _A, [CustomerID], "Occurrence2", COUNTX( _A, [CustomerID] ) )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!