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.⚡
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 lotsAnonymous the solution was provided based on the original post, if there are more tables and relationships you need to provide relevant information. having multiple tables with relationship and how tables are connected can lead to different results, same DAX expression cannot fit for all
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.⚡