Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have 2 measusres meant to count how many advisors have 0 sales and how many have between 1-4 sales. The below formula is meant to capture the second number, but as written it also captures those with 0 sales. How do I modify it to capture only those with 1-4 sales?
1-4 RTA = CALCULATE(DISTINCTCOUNT(Advisors[Advisor Name]),FILTER(Advisors,Advisors[RTAs]<5))
Thanks!
Solved! Go to Solution.
Hey,
guess this would work
1-4 RTA = CALCULATE( DISTINCTCOUNT(Advisors[Advisor Name]) ,FILTER(Advisors ,Advisors[RTAs] >= 1 && Advisors[RTAs] <=5 ) )
Regards
Hey,
guess this would work
1-4 RTA = CALCULATE( DISTINCTCOUNT(Advisors[Advisor Name]) ,FILTER(Advisors ,Advisors[RTAs] >= 1 && Advisors[RTAs] <=5 ) )
Regards
Thanks! I never would have guessed the double ampersand (&&)!
Sometimes it's the small things
Well, I'm new at this, so it's often the small things! But I surely do do appreciate the help!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |