Forum Discussion
RANKX with customizable variable
Hello everyone, I'm trying to create a dynamic ranking with variables.
I currently have a table with category and total and it has a measure that shows the ranking of each one.
However, I have an option to select values in the case of categories, which must add up, for example if I select the category or multiple categories, the original rank will dynamically update according to the selected one.
here the file with data and measures i used.
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:
8 Replies
You were close
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
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.
