Forum Discussion
Filter Table by Max Value
I have data that I am looking to filter byt he Max Order Group. The results should be one distinct intorderitemid per line with the Max Order Group results only showing. The max order group could change based on date, for example today's max order group number for the first highlighted line could be 2628 but when the data refreshes tonight, that same line could have also been in order group 2635.
Only looking to evaluate one line per intorderitemid.
awitt add a following measure and then you can have visual level filter on this
Is Max Order Group = VAR __orderGroup = CALCULATE ( MAX ( Table[OrderGrou] ), ALLSELECTED ( Table ) ) RETURN IF ( MAX ( Table[OrderGroup] ) = __orderGroup, 1, 0 )Filter where Is Max Order Group measure is 1
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.⚡
3 Replies
awitt , see lastnonblankvalue can help
last Action= lastnonblankvalue(Table[order group],max(Action))
Display with the first and second column
refer: https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak
awitt add a following measure and then you can have visual level filter on this
Is Max Order Group = VAR __orderGroup = CALCULATE ( MAX ( Table[OrderGrou] ), ALLSELECTED ( Table ) ) RETURN IF ( MAX ( Table[OrderGroup] ) = __orderGroup, 1, 0 )Filter where Is Max Order Group measure is 1
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.⚡
