Hi, I have a sample data below. What I'm trying to do is show the State which has the Max value of rows based on the distinct count of IDs. Answer = West, which has 4 IDs count I know how to show the value 4, but not the State = West. My code:
DistinctCount = DISTINCTCOUNT(Table[ID]) Max Value = MAXX(values(Table[State]),[DistinctCount])
Can anyone help me with bringing out the value "West"?