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.
Solved! Go to Solution.
Hi @GunnerJ
You seem to be using FILTER with three arguments. It takes only two. Try this, where I'm assuming you want and AND
02.Min.Task Time by SO# = CALCULATE ( MIN ( 'Open SO data'[BI_EVENT_DT_TM] ), FILTER ( ALLEXCEPT ( 'Open SO data', 'Open SO data'[BI_SO_NBR], 'Open SO data'[BI_WRKFLW_TASK_SEQ_NBR], 'Open SO data'[BI_WORK_EVENT_CD], 'Open SO data'[BI_WORKGRP] ), OR ( 'Open SO data'[BI_WORKGRP] = "CONFOLLOW", OR ( 'Open SO data'[BI_WORKGRP] = "CONST", 'Open SO data'[BI_WORKGRP] = "SUB" ) ) && 'Open SO data'[BI_WORK_EVENT_CD] = "DELAY" ) )
or this (I don't know what you are trying to do)
02.Min.Task Time by SO# = CALCULATE ( MIN ( 'Open SO data'[BI_EVENT_DT_TM] ), FILTER ( ALLEXCEPT ( 'Open SO data', 'Open SO data'[BI_SO_NBR], 'Open SO data'[BI_WRKFLW_TASK_SEQ_NBR], 'Open SO data'[BI_WORK_EVENT_CD], 'Open SO data'[BI_WORKGRP] ), OR ( 'Open SO data'[BI_WORKGRP] = "CONFOLLOW", OR ( 'Open SO data'[BI_WORKGRP] = "CONST", 'Open SO data'[BI_WORKGRP] = "SUB" ) ) ), 'Open SO data'[BI_WORK_EVENT_CD] = "DELAY" )
Hi @GunnerJ
You seem to be using FILTER with three arguments. It takes only two. Try this, where I'm assuming you want and AND
02.Min.Task Time by SO# = CALCULATE ( MIN ( 'Open SO data'[BI_EVENT_DT_TM] ), FILTER ( ALLEXCEPT ( 'Open SO data', 'Open SO data'[BI_SO_NBR], 'Open SO data'[BI_WRKFLW_TASK_SEQ_NBR], 'Open SO data'[BI_WORK_EVENT_CD], 'Open SO data'[BI_WORKGRP] ), OR ( 'Open SO data'[BI_WORKGRP] = "CONFOLLOW", OR ( 'Open SO data'[BI_WORKGRP] = "CONST", 'Open SO data'[BI_WORKGRP] = "SUB" ) ) && 'Open SO data'[BI_WORK_EVENT_CD] = "DELAY" ) )
or this (I don't know what you are trying to do)
02.Min.Task Time by SO# = CALCULATE ( MIN ( 'Open SO data'[BI_EVENT_DT_TM] ), FILTER ( ALLEXCEPT ( 'Open SO data', 'Open SO data'[BI_SO_NBR], 'Open SO data'[BI_WRKFLW_TASK_SEQ_NBR], 'Open SO data'[BI_WORK_EVENT_CD], 'Open SO data'[BI_WORKGRP] ), OR ( 'Open SO data'[BI_WORKGRP] = "CONFOLLOW", OR ( 'Open SO data'[BI_WORKGRP] = "CONST", 'Open SO data'[BI_WORKGRP] = "SUB" ) ) ), 'Open SO data'[BI_WORK_EVENT_CD] = "DELAY" )
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |