topic Re: Beginner here....Needing help with a measure. in DAX Commands and Tips

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

RAKNOW6994 — Fri, 22 Jan 2021 02:53:31 GMT

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")))

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

amitchandak — Fri, 22 Jan 2021 03:46:08 GMT

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")))

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

RAKNOW6994 — Fri, 22 Jan 2021 03:50:43 GMT

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

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

amitchandak — Fri, 22 Jan 2021 04:19:20 GMT

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")))

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")))

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

RAKNOW6994 — Sat, 23 Jan 2021 06:40:01 GMT

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.