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:
Thanks lbendlin.
The case is to update this table with A + C + E + F which would give the total value of 16 and would be number 1 in the ranking, looking as follows.
How can do this?
In other words, the ranking remains the original and the selected categories become a variable adding the name of the category and the value it has in each one
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.
I cannot assist you with this request, I don't think that is right. Maybe someone else can help you further.