Forum Discussion
Solved
Count IFS Help!
Hey Guys, Needs some help with a new calculated column..... I have a set of events that must go through 6 tasks before they are considered completed through the entire process....... In excel, I w...
Please see if this approach meets your need in a calculated column expression.
Completed Process = VAR rejections = NOT ( ISBLANK ( CALCULATE ( COUNTROWS ( Review ), ALLEXCEPT ( Review, Review[VIOLATION_ID] ), Review[QR_ACTIONTYPE] = "REJECT" ) ) ) VAR accepted = NOT ( ISBLANK ( CALCULATE ( COUNTROWS ( Review ), ALLEXCEPT ( Review, Review[VIOLATION_ID] ), Review[QUEUECODE] = "WF_REVIEW_IMAGES", Review[QR_ACTIONTYPE] = "ACCEPT" ) ) ) RETURN IF ( OR ( rejections, accepted ), 1, 0 )If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Please see if this approach meets your need in a calculated column expression.
Completed Process =
VAR rejections =
NOT (
ISBLANK (
CALCULATE (
COUNTROWS ( Review ),
ALLEXCEPT ( Review, Review[VIOLATION_ID] ),
Review[QR_ACTIONTYPE] = "REJECT"
)
)
)
VAR accepted =
NOT (
ISBLANK (
CALCULATE (
COUNTROWS ( Review ),
ALLEXCEPT ( Review, Review[VIOLATION_ID] ),
Review[QUEUECODE] = "WF_REVIEW_IMAGES",
Review[QR_ACTIONTYPE] = "ACCEPT"
)
)
)
RETURN
IF ( OR ( rejections, accepted ), 1, 0 )
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
