Calculate number of frequent customers

[Syndicate_Admin]

Hello community.

My doubt is as follows:

I have to count the number of frequent customers.

A frequent customer is one who has made 3 or more visits (transactions) in the month consulted.

I already have the measure that counts the transactions that the client has made, it is as follows:

Based on this measure I create another one that makes me the same calculation, but with date filter context, shown in the following image:

If I add a condition where I put 1 to customers who had more than 2 visits, the code would look like this:

And the result would look like the following table shown:

On the Frequently Customers card should be 5, because of the total customers, only 5 had more than 2 visits.

The problem is that in the result of the measure it does not add it up, it just labels it.

Would you really appreciate it if any of you had any recommendations about it?

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.  Please ensure that you share only relevant tables/tabs in that file and all information in that file is in English.

Thank you.

[Syndicate_Admin]

I really appreciate your comment.

I have an inconvenience, the tables are from Power Query, they have 25,000,000 approx...

These are the tables that are relevant to this case...

[v-kkf-msft · Accepted solution]

Hi @Syndicate_Admin ,

Try the following formula:

Measure = 
IF(
    ISFILTERED(TransactionsPerDay[IdCustomer]),
    [Frequently Customers],
    SUMX(ALLSELECTED(TransactionsPerDay[IdCustomer]), [Frequently Customers])
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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