Beginner here....Needing help with a measure.

[RAKNOW6994]

I want to create a measure that totals only the REPORTED HOURS, when EI_STEPNUM = “20” and DESCRIPTION contains “AVA”.

Here is my attempt at writing the measure:

MEASURE = CALCULATE(SUM('VOL - Maximo Labor Transactions'[REPORTEDHOURS]),FILTER('VOL - Maximo Labor Transactions','VOL - Maximo Labor Transactions'[EI_STEPNUM]="20"),FILTER('Work Order Management','Work Order Management'[DESCRIPTION]=CONTAINS('Work Order Management','Work Order Management'[DESCRIPTION],"AVA")))

[amitchandak]

@RAKNOW6994 , is EI_STEPNUM is text or numeric ?

Please check datatype for all columns and changes

MEASURE = CALCULATE(SUM('VOL - Maximo Labor Transactions'[REPORTEDHOURS]),FILTER('VOL - Maximo Labor Transactions','VOL - Maximo Labor Transactions'[EI_STEPNUM]=20),FILTER('Work Order Management','Work Order Management'[DESCRIPTION]=CONTAINS('Work Order Management','Work Order Management'[DESCRIPTION],"AVA")))

[RAKNOW6994]

The field is set up as text.  However, the values are all numbers, but I am not doing any calculations/math with them.  

[amitchandak]

@RAKNOW6994 , this error is typically a datatype error. I Think contains with = is problem

Other options are containsstring , search, find

MEASURE = CALCULATE(SUM('VOL - Maximo Labor Transactions'[REPORTEDHOURS]),FILTER('VOL - Maximo Labor Transactions','VOL - Maximo Labor Transactions'[EI_STEPNUM]=20),FILTER('Work Order Management',CONTAINS('Work Order Management','Work Order Management'[DESCRIPTION],"AVA")))

or

MEASURE = CALCULATE(SUM('VOL - Maximo Labor Transactions'[REPORTEDHOURS]),FILTER('VOL - Maximo Labor Transactions','VOL - Maximo Labor Transactions'[EI_STEPNUM]="20"),FILTER('Work Order Management',CONTAINS('Work Order Management','Work Order Management'[DESCRIPTION],"AVA")))

[RAKNOW6994]

I appreciate your feedback Amitchandak.

Hmmmm....
The second formula: MEASURE = CALCULATE(SUM('VOL - Maximo Labor Transactions'[REPORTEDHOURS]),FILTER('VOL - Maximo Labor Transactions','VOL - Maximo Labor Transactions'[EI_STEPNUM]="20"),FILTER('Work Order Management',CONTAINS('Work Order Management','Work Order Management'[DESCRIPTION],"AVA")))

It processed, but did not yield any results.  There are reported values with EI_STEPNUM which equal 20.  But for whatever reason, it is not totaling them.