Forum Discussion
Filter Table by Max Value
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.⚡
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.⚡