Forum Discussion

CL7777's avatar
CL7777
Icon for Helper III rankHelper III
6 years ago
Solved

Counting repeat customers

HEllo Forum,   I am an intermediate dax user and Im struggling with this task   I want to count repeat customers in a table, keeping all filters applied in the visual.   Example file customer ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    6 years ago

    CL7777 

     

    I see what you mean. Tricky this one, but I think I've cracked it.

    Give this a try:

    1) First measure: 

    Distinctcount years = CALCULATE(DISTINCTCOUNT('Customer data'[year]); 
                      ALLEXCEPT('Customer data'; 
                      'Customer data'[Customer]; 'Customer data'[Country];'Customer data'[part number]))

    2) Final Measure to deliver repeating customers:

    Repeating Customers = CALCULATE(DISTINCTCOUNT('Customer data'[Customer]);
                       FILTER(ALL('Customer data'[Customer]);
                        [Distinctcount years]>1)) +0
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

I am not sure if this would help but from my understanding you can

1.select write a DAX expression as Distinctcount(customer)

2.select a multirow KPI card add measure from step1 and add customer field too!

 

 

you will be able to see the names of customers and the counts that they appear after your filters. Thanks