Forum Discussion

Chris154's avatar
Chris154
Frequent Visitor
2 years ago
Solved

Categorize with measure based on table range

Hi team,   I am trying to create a leaderboard where our employees can reach new levels based on the number of issues they have solved. For this I have two tables:  1) Issue log, which delivers t...
  • Irwan's avatar
    Irwan
    2 years ago

    hello Chris154 ,

     

    i am a beginner but is this result match to your need?

     

    Table 2 is your reference table:

     

    Hope this will give you some help.

    Thank you.

Chris154's avatar
Chris154
Frequent Visitor
2 years ago

Hi Irwan ,

 

thanks so much! That was what I needed.

It did give me a bit of a headache afterwards, as my Level names are not "Level 1", "Level 2" etc. but fun words like "Curious Carrot" etc.

I had the issue, that it would return me the maximum value alphabetical wise instead of the corresponding Level name to the maximum achieved Issues completed.

 

I fixed this by then using the result in a lookupvalue formula:

Current Level = LOOKUPVALUE('Level Overview'[Level],'Level Overview'[Issues completed], MAXX(FILTER('Level Overview','Level Overview'[Issues completed]<='Issue Log'[Issues closed]),'Level Overview'[Issues completed]))

 

Just posting this if anyone else runs into a similar issue with this.

 

Again, thank you very much!

Irwan's avatar
Irwan
Icon for Super User rankSuper User
2 years ago

Glad to be a help.

Thank you.