Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
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.
Hi @kl8818
have you tried
= CALCULATE(COUNTA('User Summary'[First Login]),'User Summary'[Total Daily Logins] >= 2 )
?
Hi @kl8818
have you tried
= CALCULATE(COUNTA('User Summary'[First Login]),'User Summary'[Total Daily Logins] >= 2 )
?
Thank you! I first tried it with a => and it showed an error. I didn't think to attempt by reversing. That worked!
User | Count |
---|---|
19 | |
18 | |
16 | |
13 | |
13 |
User | Count |
---|---|
9 | |
8 | |
8 | |
7 | |
6 |