How to calculate actual counts per repeating customer

[Anonymous]

Hello folks,

I have somewhat easy task but I can't get it to work. I need to get the actual counts of repeating customer. I get the repeating customers measure but it doesn't have the counts. This is the code:

Repeating Customers =

COUNTROWS(

FILTER(

VALUES( 'Order'[AccountId] ),

CALCULATE( COUNTROWS( 'Order' ) ) > 1

)

)

Now I need to get actual counts of repeating customers. So for instance I need to have that structure:

Customer   Count

A                2

B                5

C                3

And so forth. Just to give a clearer specs. I will need to use that distinct count as a clicer and in visuals. So, in a clustered column chart I would put the sum of counts and the counts values:

count = 3

sum of distinct counts = 150

count = 4

sum of distinct couns = 70

count = 5

sum of distinct counts = 138

I hope I explained it well. Let me know if this is not clear.

Thanks,

Stan

[Anonymous]

Hi @Anonymous,

Please share some dummy data and expected results for test, it will help to test coding formula.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[AntrikshSharma]

I believe it should be like this:

Repeating Customers =
COUNTROWS (
    FILTER ( VALUES ( Customer[Column] ), CALCULATE ( COUNTROWS ( 'Order' ) ) > 1 )
)

[Anonymous]

This also gives me a count of 1 per each repeating customer. I need actual row count per customer. 

[amitchandak]

@Anonymous , Try like

countx(filter(summarize('Order', 'Order'[AccountId], "_1", countrows('Order')),[_1]>1),[AccountId])

[Anonymous]

Thank you but this just gives me a set of repeating customers. If I pull an AccountId to matrix and then the new measure I just see a list of repeating customers with the count of 1 for each. I need to have actual count of rows per repeating customer.