Forum Discussion
Max Op Number
Anonymous add this measure
Max Op = CALCULATE ( MAX ( Table[Op Number] ), ALLEXCEPT ( Table, Table[Work Order] ) )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Anonymous add this measure
Max Op = CALCULATE ( MAX ( Table[Op Number] ), ALLEXCEPT ( Table, Table[Work Order] ) )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
I added the following as both a column and measure. It gives the highest op number for the entire table (2000) intead of the highest for each work order:
Last Op =
Calculate(
Max('pub Op_Max'[op_wo_op)),
AllExecpt('pub Op_Max','pub Op_Max[op_wo_nbr])
)I suspect it is the ALLEXECPT command but I don't know what to replace it with
Anonymous it will work if you view the data in a table visual, put order number and this new measure and check the result, if not then share how you are using this measure.
I am using a table visual. Unfortunately I cannot upload the table b/c of IT setting at corporate. In fact I'm using my private computer to type this. It is a simple table:
Work Order Measure
16122 2000
161844 2000
162450 2000
The two tables are linked by a separate filed wo_lot in an one-to-many relationlship. I don't use wo_nbr since each work order can have several lots