Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone
I have a table that I'm trying to count if between two numbers. See the code below. The code looks to count each row if a rate is greater than or equal to 4 and less than or equal to 5.
However, what seems to be coming back is, anything less or equal to five, don't come in.
# of Employees at or below 5 =
CALCULATE (
COUNTROWS ( 'Current' ),
FILTER ( 'Current', 'Current'[Rates] <= 4 >= 5 )
)
Solved! Go to Solution.
Hi @GradStudent2020 ,
Please check if this formula works.
CALCULATE (
COUNTROWS ( 'Current' ),
FILTER ( 'Current', 'Current'[Rates] >= 4 && 'Current'[Rates] <= 5 )
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
Hi @GradStudent2020 ,
Please check if this formula works.
CALCULATE (
COUNTROWS ( 'Current' ),
FILTER ( 'Current', 'Current'[Rates] >= 4 && 'Current'[Rates] <= 5 )
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |