Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to create a measure that totals only the REPORTED HOURS, when EI_STEPNUM = “20” and DESCRIPTION contains “AVA”.
@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")))
The field is set up as text. However, the values are all numbers, but I am not doing any calculations/math with them.
@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")))
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |