Summarize table with filtering only values that are duplicated 3 times

[Anonymous]

Hi everyone,

I have a table of customers with invoice date like the following:

Customer Number	Invoice Date
123	11/18/2020
123	11/17/2020
123	11/16/2020
124	11/16/2020
124	11/15/2020
125	11/16/2020

I'm trying to summrize the table to have the distinct customer number who have 3 or more invoices, I tried the following dax code but it returning the whole list of customers without in filtering, it should return a list of only one customer which is "123".

This is the PBIX.

Table = SUMMARIZE(FILTER('Customer Invoices',DISTINCTCOUNT('Customer Invoices'[Invoice Date])>=3),'Customer Invoices'[Customer Number])

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[mahoneypat · Accepted solution]

Please use this expression instead

Table 2 =
FILTER (
    DISTINCT ( 'Customer Invoices'[Customer Number] ),
    CALCULATE (
        COUNT ( 'Customer Invoices'[Invoice Date] )
    ) >= 3
)

Regards,

Pat

[Anonymous]

Thanks it works!

Though I have a quiestion can I insert a filter to just return the October distinct values for example like this filter month(invoice Date)=10?