Forum Discussion
Solved
Auto-exist challenge
Hello With the the help of the community I could create a sport result ranked table. In one table the ranking can be filtered on - month - week - day and based on date further filtered on gen...
I found the solution on replacing ALLSELECTED with ALLEXCEPT.
_mRank = RANKX ( ALLEXCEPT( RfvRefined, RfvRefined[Gender], RfvRefined[MonthNo], RfvRefined[WeekNo], RfvRefined[Start], RfvRefined[ContestId], RfvRefined[Nation] ), [_max],, DESC, DENSE )
I found the solution on replacing ALLSELECTED with ALLEXCEPT.
_mRank = RANKX ( ALLEXCEPT( RfvRefined, RfvRefined[Gender], RfvRefined[MonthNo], RfvRefined[WeekNo], RfvRefined[Start], RfvRefined[ContestId], RfvRefined[Nation] ), [_max],, DESC, DENSE )