DAX SQL window function equivalent

[pbix]

Hello,

I would like to create a calculated column that returns a total row count per customer, as below.

http://imgur.com/WJ2MzJS

To do this with SQL, one approach would be to use a window function like:

COUNT(*) OVER (PARTITION BY CUSTOMER ORDER BY NULL)

Could someone please demonstrate how to achieve the same result using DAX?

Thanks!

Pbix

[Eric_Zhang · Accepted solution]

@pbix

Check

Column =
COUNTAX (
    FILTER ( 'Table', EARLIER ( 'Table'[Customer No.] ) = 'Table'[Customer No.] ),
    'Table'[Product Purchased]
)

 

A good site for your reference.

[Shmidtk]

What if we have unsorted list of Customer No.? They this formula shouldn't work, yes?

[pbix]

Lovely, thanks very much.