Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
I'm trying to create a "between" slicer the includes or excludes categories based on the number of times they appear in the data set.
Want to filter out categories that only appear a few times to only focus on those that appear in high volume.
Thanks for any help!
Solved! Go to Solution.
I kept searching and found this that just worked - created new tablet with below.
= GROUPBY(Table1,Table1[User ID],"Count of login",COUNTX(CURRENTGROUP(),Table1[Login time]))
I kept searching and found this that just worked - created new tablet with below.
= GROUPBY(Table1,Table1[User ID],"Count of login",COUNTX(CURRENTGROUP(),Table1[Login time]))
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 76 | |
| 38 | |
| 31 | |
| 27 | |
| 26 |