Forum Discussion
RANKX with customizable variable
Hi Anonymous
In order for those combined category to appear based on the slicer selection, they need to physically exist first in your which means that there should be a column in your model showing all the possible combinations of those categories. Example:
Adding the same data to the same visual twice is a design red flag. Don't do it. Use separate visuals (as you already did)
lbendlin I don't understand, because the idea is to add it to the table where the visual already exists, that is, I keep the table and reorder it according to the selectable.
This is the final result that I expect in the case you mentioned with the selected options, that is, I add the sum of each selected category, this way it is top 1 in the ranking.
If I do not select any item, the table continues without changing the ranking, as follows.
However, if I select an item it must be iterated and added to its total and moved to a new position in the ranking, example image below.