Countrows where a customer is mailed more than one time

[Anonymous]

I have a mailers table where each row shows a mailer sent to a customer.

There are times when we send more than one mailer in a month to a customer.

I'd like to create a measure that tells me how many customerIDs show up more than once?

Basically count rows where count(customerids)>1

Example table

[ChandeepChhabra]

@Anonymous 

This measure results in number of customers who were sent more than once

Count = COUNTROWS(FILTER(VALUES(Mailers[CustomerID]),COUNTA(Mailers[CustomerID])>1))

[Arjunarao · Accepted solution]

Calculation1 = COUNTROWS(
FILTER( VALUES (Sheet1[CustomerID]), COUNTROWS(Sheet1)>1 )
)

Calculation2 = COUNTROWS(
FILTER( VALUES ( Sheet1[CustomerID] ) , [Count of CustomerID] > 1 )
)

https://drive.google.com/file/d/17TZgQPIN18Ri8LoeNsJpkWNz_1fJKnbB/view?usp=sharing

[Anonymous]

Thank you so much @Arjunarao !

Many folks had similar answers, appreciate the feedback from everyone, thanks!!

[Ashish_Mathur]

Hi,

In a slicer, select any one month.  Drag this measure to a card visual

=COUNTROWS(FILTER(VALUES(Table1[CustomerID]),COUNTROWS(Table1)>1))

Hope this helps.

[d_gosbell]

You could use logic like the following:

COUNTROWS( FILTER( VALUES( Table1[CustomerID] ) , [Count of CustomerID] > 1 ) )