Forum Discussion

Toni_H's avatar
Toni_H
Frequent Visitor
4 years ago
Solved

Rank Output based on Selected Criteria

Hello, Essentially I need to figure out a way to see a list of students based on best fit to my selected search criteria. Example: A user chooses 5 criteria for search (range between 1-10), any st...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Toni_H , First create a measure on match criteria

new measure =
var _max = maxx(allselected(criteria1),criteria1[Date])
var _min = minx(allselected(criteria1),criteria1[Date])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[attitude] >=_min && 'Table'[attitude] <=_max))

 

add other too

 

then create a measure

 

Rankx(allselected(Table[Name]),[new measure],,desc,dense)

 

Toni_H's avatar
Toni_H
Frequent Visitor
4 years ago

Thank you for taking the time to respond.
This does work, but I would need to create a rank measure that considers all the criteria selected in the slicers.

Not sure how that would work...

Thanks again for your help,

TH