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
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: