Forum Discussion

rcorn's avatar
rcorn
Frequent Visitor
3 years ago

RANKX value changes for filtered value when it shouldnt

I am using a RANKX formula to rank a category by UPB($). As shown in the screenshot I have two tables, the first table with only the green highlighted category with the rank 8, and the second table w...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi rcorn ,

 

To avoid this issue, you can modify your formula to use the ALLSELECTED function instead of the ALL function. The ALLSELECTED function returns all the selected values in the current filter context, including any filters applied to the table. Here is the modified formula:

Current Rank =
RANKX(ALLSELECTED(table[category]),[SUM of UPB($)],,,Skip)

 

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

rcorn's avatar
rcorn
Frequent Visitor
3 years ago

Thanks for the response, ALLSELECTED will not work in this case as it limits ranking to only the green category in the first table showing rank 1 where I want it to continue to show correct rank of 7 (as shown in table 2)

  • PeterChen's avatar
    PeterChen
    Helper I
    2 years ago

    Having same issue.... Have you solved it?