Forum Discussion
Solved
Calculated Column: Return String associated w Highest value in a subset group
Hi everyone. I would really appreciate some help with the following issue that I have not been able to figure out after scouring the forums. I have the following 3 tables: Table_Visit Vi...
Easy enough,
This works! But now I need to ignore all individual Category A procedure codes. Just act like they aren't there.
In Visit 1, Codes 10 and 22 would be ignored. Procedure Code 55 would now be the highest RVU value and the Visit Category would change from A to C.
I have tried the following modification with a one to many relationships btw tables, but somehow it isn't filtering correctly. Instead it's returning the same Category for ALL rows...
Any ideas?
Category CC =
MAXX(
CALCULATETABLE(
TOPN(1, VISIT, VISIT[RVU Value]),
ALLEXCEPT(VISIT, VISIT[Visit]),
FILTER( VISIT, RELATED( PROC [Category]) <> "A")
),
RELATED( PROC [Category]]
))