Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
I have a table with the following columns:
Dates | User ID | # of Purchases
1/2 1 3
1/2 2 2
1/3 1 4
1/3 2 1
1/5 1 2
Im trying to find a way to calculate the number of unique users that made X amount of purchases between any given dates. Ideally i would have a slicer for a date range and purchase count to find the number of users. Any help would be great to calculate this. Thank you.
Hey @kpatel49,
please describe the expected result based on the data you provide.
Regards,
Tom
If I chose a specific date range and I wanted to know how many users made let's say made a total of 3 purchases during that date range.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 81 | |
| 73 | |
| 46 | |
| 35 |