Reply
smmoore34
Helper II
Helper II
Partially syndicated - Outbound

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

I have the following table example:

Customer IDTransactionIDAge
110142
210229
210329
210429
310563
310663
410745
510833
510933

 

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.

1 ACCEPTED SOLUTION
DataNinja777
Super User
Super User

Syndicated - Outbound

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.  

DataNinja777_0-1716472232742.png

I attach an example pbix file.  

View solution in original post

3 REPLIES 3
DataNinja777
Super User
Super User

Syndicated - Outbound

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.  

DataNinja777_0-1716472232742.png

I attach an example pbix file.  

Syndicated - Outbound

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

Thanks!!!

avatar user
Anonymous
Not applicable

Syndicated - Outbound

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

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)