- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Create a filter that only shows distinct customers that have 2 or more transactions
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-11-2024 10:27 AM | |||
08-14-2024 10:51 AM | |||
08-19-2024 08:35 PM | |||
06-28-2024 07:50 AM | |||
02-15-2024 06:03 AM |
User | Count |
---|---|
141 | |
110 | |
81 | |
61 | |
46 |