Create measure of sum of rows in table grouped

[zausten]

Hi, 

I have a table containing a transaction date, customer name and some other values.

I want to be able to apply a fitler to that table to remove records where the customer only has transactions in a single month.

So in the case below remove joe because he only has transactions in a single month

I have tried using countrows but without sucess

thanks!

Tranaction date	Customer Name	Amount
2023-01-01	Joe	1
2023-01-01	Mary	2
2023-02-01	Mary	3
2023-03-01	Mary	4
2023-04-01	Mary	5
2022-11-01	Ted	6
2022-12-01	Ted	7
2023-01-01	Ted	4
2023-02-01	Ted	4
2023-03-01	Ted	7
2023-04-01	Ted	8

[zausten]

thanks @pratyashasamal 

Thats getting closer to what I need, however never as straightforward!  the table is already being fitlered dynamically using an unlinked date table to return the previous 6 months of transactions.  we do this by below dax. this way the user can select January23 and get the last 6 months transactions from the fact table.

So what I really need is a sum of the transactions per customer on the filtered table.  Hope that makes sense

dynamic6monthflag =

var to_date= selectedvalue('date table'[endofmonth])

var from_date = selectedvalue('date table'[firstofmonth])

var flag =
IF(max(Table[TransactionDate]) in DATESBETWEEN(Table[TransactionDate],from_date,to_date),1,0)
return flag

[pratyashasamal]

Hi @zausten ,
First keep add the date column and other columns that you want and apply the filter to month you want .
Add a measure to count the customers

Count Customer = CALCULATE( COUNT(Orders[Order ID]), ALLEXCEPT(Orders, Orders[Customer ID]))
Then apply the filter on Count Customer to be greater than 1 

Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C