If one item in hierarchy is zero, mark all incomplete

[thrillho32]

Hello,

I am looking for a little help on what seems like an easy task.

I have a table that looks like this:

Order#	Item#	ItemComplete
123	1	1
123	2	1
123	3	0
123	4	1

I am looking to add a column that marks this order as "incomplete" on every record as item# 3 has not been completed.  I'd like the column to show as below:

Order#	Item#	ItemComplete	OrderStatus
123	1	1	Incomplete
123	2	1	Incomplete
123	3	0	Incomplete
123	4	1	Incomplete

Greatly appreciate any help!

[Ashish_Mathur]

Hi,

This calculated column formula works

Status = if(CALCULATE(COUNTROWS(Data),FILTER(Data,Data[Order#]=EARLIER(Data[Order#])&&Data[ItemComplete]=0))=1,"Incomplete","Complete")

Hope this helps.

[vicky_]

Try something like:
OrderStatus = IF(CALCULATE(MIN([ItemComplete]), ALLEXCEPT(TableName, [Order])) = 0, "Incomplete")