Forum Discussion
Solved
Find row value based on two other columns
I want to find the type based on a numeric column for each state. Here is an brief example of the data I have. I have a location column (State), a category column (Type), and a value column. For each...
prof_hoo Try this measure, change table and column name as per your model
Top Type = CALCULATE ( MAX ( HighType[Type] ), TOPN ( 1, ALLSELECTED ( HighType[Type] ), CALCULATE ( SUM ( HighType[Value] ) ), DESC ) )Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to 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.
parry2k
Super User
Super Userprof_hoo I don't understand what do you mean by hardcoding, you provided the logic and the solution is based on your ask.
You need to provide more details to explain the logic so that community can provide you the help.
Apologies; I edited my post to better explain the logic I'm looking to create.