Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Which function to use?

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

  • HI Anonymous 

     

    Try following

     

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

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion

    HI Anonymous 

     

    Try following

     

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