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 ...
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)