stbrooks13
New Member
- Joined
- Dec 9, 2014
- Messages
- 40
I would like to return a demographics category's maximum (lowest) dimension in text form. I'm able to determine the maximum value of the dimension, but I can't figure out how to return its text.
Please see sample below. The maximum dimension for the birth year demographics category is
fairness (on the right at 7), but my Dim Max Text formula is returning "Respect" for all categories (which is interesting because it's not the maximum dimension for any category).
Dim Max Text = MAXX(FILTER(Results,[Dim Rank]=[Dim Max]),Results[Dimension])
Dim Rank = RANKX(ALLSELECTED(Results[Dimension]),RANKX(ALLSELECTED(Results[Dimension]),[Avg Score],,,Dense)+RANKX(ALLSELECTED(Results[Dimension]),[STMT Consistency],,ASC,Dense),,ASC,Dense)
Dim Max = MAXX(SUMMARIZE(Demographics,Demographics[Category],"Max Dim",[Dim Rank]),[Max Dim])
https://photos.app.goo.gl/j887Gsurhzmi6goJ6
Please see sample below. The maximum dimension for the birth year demographics category is
Dim Max Text = MAXX(FILTER(Results,[Dim Rank]=[Dim Max]),Results[Dimension])
Dim Rank = RANKX(ALLSELECTED(Results[Dimension]),RANKX(ALLSELECTED(Results[Dimension]),[Avg Score],,,Dense)+RANKX(ALLSELECTED(Results[Dimension]),[STMT Consistency],,ASC,Dense),,ASC,Dense)
Dim Max = MAXX(SUMMARIZE(Demographics,Demographics[Category],"Max Dim",[Dim Rank]),[Max Dim])
Last edited:
