Count orders based on conditions from other columns

[jwin2424]

Here is a small dataset sample. I have a single table and no connecting relationships. 

Run Date	Order #	On ATP	Order on ATP
8/9/2023	1	TRUE	TRUE
8/9/2023	1	TRUE	TRUE
8/9/2023	1	TRUE	TRUE
8/9/2023	2	FALSE	FALSE
8/9/2023	2	TRUE	FALSE
8/9/2023	2	FALSE	FALSE
8/10/2023	1	TRUE	TRUE
8/10/2023	1	TRUE	TRUE
8/10/2023	1	TRUE	TRUE
8/10/2023	2	FALSE	FALSE
8/10/2023	2	TRUE	FALSE
8/10/2023	2	FALSE	FALSE
8/11/2023	1	TRUE	TRUE
8/11/2023	1	TRUE	TRUE

Each day, I need to determine if the entire order is on ATP or not. The desired result is the last column. As you can see, not all order lines are on ATP. I need a column or measure that returns a TRUE statement if the all lines on the order for that day are TRUE for On ATP. 

Hope that makes sense. 

Thanks, 

[ThxAlot · Accepted solution]

Simple enough,

[jwin2424]

Thank you! I was using EARLIER on run date, but not on order #. 

[tamerj1]

Hi @jwin2424 

please try

Order on ATP =
VAR CurrentOrderATPs =
CALCULATETABLE (
VALUES ( 'Table'[On ATP] ),
ALLEXCEPT ( 'Table', 'Table'[Run Date], 'Table'[Order #] )
)
RETURN
IF ( COUNTROWS ( CurrentOrderATPs ) = 1, CurrentOrderATPs, FALSE )

[jwin2424]

As a side note, this worked as well. Thank you