How to multiple order numbers at a line level?

[Utsav279]

Hi Power Bi Team, I am trying trying to solve a problem I am running into a power query. I have an order number with more than one line and if only one item is being held for that order I want the rest of the occurrence of other lines of the same order number to be held.

Ex: 

Order Num H/O  Hold Reason

96787229

Held

MIN_ExpectedDate

96787229

Open

null

I have created a conditional column to calculate this H/O column: 

How I want it displayed is if one Order number is held then the rest of the same order number lines should show being held even if they have shipped and not meet the condition of being null in the screenshot.

[Utsav279]

@ryan_mayu Thank you so much for helping with this issue the dax code worked and appreciate your support!

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

@Utsav279 

i think you can use DAX to create a column

Column = maxx(FILTER('Table','Table'[order]=EARLIER('Table'[order])&&'Table'[H/O]="Held"),'Table'[H/O])