Which function to use?

[Anonymous]

I am trying to figure out which combination of count/filter functions to use to get my data to look at a specific date range for a job and return a count of how many times the amount is <= 25.00.  Does anyone know what measure to use?  

My data looks like this:

Date             Job    Amount

1/1/2016       A         24.00

8/1/2016       A         16.00

3/1/2017       B          40.00

7/1/2017       B          23.00

11/1/2017     B          19.00

4/1/2018       B           5.00

9/1/2018       C          40.00

3/1/2019       C          22.00

What I want it to return is:

Job   Amount Less than 25

A              2

B              3

C              1

[Zubair_Muhammad · Accepted solution]

HI @Anonymous 

Try following

Measure=
CALCULATE ( COUNTROWS ( TableName ), TableName[Amount] <= 25 )