Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
2 years ago
Solved

customers count

customers count are not showing correctly, please find below pbx file  pbix file : https://drive.google.com/file/d/1LeyNvAuC-Od6vTplCsG1MYCVwdkkhtJ5/view?usp=drive_link          
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi powerbiexpert22 

    You were unable to calculate the number of customers because there is no connection between customers and dates.

    If the intention was to calculate the number of customers who made purchases in different countries by year, then the required formula is:

    RepeatCustomers =
    DISTINCT COUNT('Internet Sales'[Customer Key])

    The updated pbix is attached

    If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.

     

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Hi powerbiexpert22 

You were unable to calculate the number of customers because there is no connection between customers and dates.

If the intention was to calculate the number of customers who made purchases in different countries by year, then the required formula is:

RepeatCustomers =
DISTINCT COUNT('Internet Sales'[Customer Key])

The updated pbix is attached

If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.