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