Forum Discussion
Helper IIHelp me understand these measures
Hi RingoSun ,
Looking at the code basically you have the following setup:
RingoSun wrote:
In this metric you are checking if there is one value selected on the TOPN table, if you have more than one value selected this metric returns false, so when you have one value of the topN you return that value, if you have more than one you return 10.
RingoSun wrote:On this second measure you do the same thing so check if there is a single category select and if that is true you return the ranking of sales based on the category
RingoSun wrote:On this last measure you check if the Categoryrank is lower or equal to the TOPN number, so basically if the Ranking is lower or equal than your TOPN you get a value of 1 otherwise you get a value of 0 when you filter based on the 1 your visualization only presents the values that are lower than the SelectedTopNumber
Super UserHi RingoSun ,
Looking at the code basically you have the following setup:
RingoSun wrote:
In this metric you are checking if there is one value selected on the TOPN table, if you have more than one value selected this metric returns false, so when you have one value of the topN you return that value, if you have more than one you return 10.
RingoSun wrote:
On this second measure you do the same thing so check if there is a single category select and if that is true you return the ranking of sales based on the category
RingoSun wrote:
On this last measure you check if the Categoryrank is lower or equal to the TOPN number, so basically if the Ranking is lower or equal than your TOPN you get a value of 1 otherwise you get a value of 0 when you filter based on the 1 your visualization only presents the values that are lower than the SelectedTopNumber