Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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" )
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
68 | |
34 | |
27 | |
26 |
User | Count |
---|---|
98 | |
96 | |
60 | |
44 | |
40 |