Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
@Anonymous
Check
Column = COUNTAX ( FILTER ( 'Table', EARLIER ( 'Table'[Customer No.] ) = 'Table'[Customer No.] ), 'Table'[Product Purchased] )
A good site for your reference.
@Anonymous
Check
Column = COUNTAX ( FILTER ( 'Table', EARLIER ( 'Table'[Customer No.] ) = 'Table'[Customer No.] ), 'Table'[Product Purchased] )
A good site for your reference.
What if we have unsorted list of Customer No.? They this formula shouldn't work, yes?
Lovely, thanks very much.