Counting duplicates in a calculated column

Anything related to PowerPivot and DAX Formuale
danielco
Posts: 4
Joined: Mon Feb 18, 2019 7:53 pm

Counting duplicates in a calculated column

Postby danielco » Tue Dec 22, 2020 12:25 am

Hello,

I want to count occurences in the 'Count' column as shown on the attached image. First row is 2 because there are two "Jan" month and "A" entity on the same row.
I hope it's clear (english is not my mother tongue).

Thanks in advance.

Daniel
Attachments
IMG.png
IMG.png (13.24 KiB) Viewed 123 times

rwfigtree
Posts: 22
Joined: Tue Jan 05, 2021 8:49 pm
Location: Sydney, Australia

Re: Counting duplicates in a calculated column

Postby rwfigtree » Tue Jan 05, 2021 8:54 pm

=CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[f1]=EARLIER(Table1[f1]) && Table1[f2]=EARLIER(Table1[f2])))


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 5 guests