Forum Discussion

Anonymous

Not applicable

9 years ago

Solved

DAX SQL window function equivalent

Hello,

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

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

Anonymous

Check

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

A good site for your reference.