Create a filter that only shows distinct customers that have 2 or more transactions

[smmoore34]

I have the following table example:

Customer ID	TransactionID	Age
1	101	42
2	102	29
2	103	29
2	104	29
3	105	63
3	106	63
4	107	45
5	108	33
5	109	33

I want to be able to filter only on those customers that have 2 or more transactions so that I can produce a report on the demographics of customers making frequent purhcases.

[DataNinja777 · Accepted solution]

Hi @smmoore34 ,

You can achive your required output in many different ways and one of them is to create a separate dimension table for customers and create a calculated column indicating which customers purchased multiple times and use in the slicer to filter.  

I attach an example pbix file.  

[smmoore34]

Worked perfectly!  The example pbix file made it easy for me.

Thanks!!!

[Anonymous]

In filter plane add a filter using Transaction ID > 1.