- 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
Count Formula
I used quick measure and this is the formula it populated. However, I need to adjust it to be "a greater than/equal to 2" versus highlighting every individual number so I do not have to update it each time when new variables are added to the data set.
= CALCULATE(COUNTA('User Summary'[First Login]),'User Summary'[Total Daily Logins] IN {2,3,4,5,6,7,8})
I believe the IN is what I need to adjust but I have not found anything that points me in the right direction. Could someone help me adjust this formula?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @kl8818
have you tried
= CALCULATE(COUNTA('User Summary'[First Login]),'User Summary'[Total Daily Logins] >= 2 )
?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @kl8818
have you tried
= CALCULATE(COUNTA('User Summary'[First Login]),'User Summary'[Total Daily Logins] >= 2 )
?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you! I first tried it with a => and it showed an error. I didn't think to attempt by reversing. That worked!

Helpful resources
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
10-20-2024 07:43 AM | |||
02-12-2025 06:48 AM | |||
06-19-2025 12:30 PM | |||
07-03-2024 07:46 AM | |||
03-27-2025 08:16 PM |
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |