Repeat Orders, Purchased more than once

DAX DAX Showcase
2

Hi @michael.gyure,

Give this a go.

Multiple Purchases 2 = 
VAR t = 
FILTER(
    ADDCOLUMNS( 
        VALUES( 'Ecommerce Items'[Buying Company ERP] ),
        "@Count", CALCULATE( COUNTROWS( 'Ecommerce Items' ))
    ), [@Count] >1
)
RETURN

SUMX( t, [@Count] )

I hope this is helpful

1 Like