Forum Discussion
Multi-Variate Ranking
if you want the rank to be dynamic I think it's better to use measure rather than calculated column
what is the basis for rank? SUM of [Premium]?
Thank you for your response. I am tring to use a measure, but i was trying to illustrate how the measure should work, so i apologize if it came accross as a calc column. The basis for the rank is sum of premium, but i want to include/exclude different companies/coverages and have the rank change. In my dashboard i am checking the accuracy of the measure by basically rebuilding the table and selecting a handful of policies to make sure the ranking function works properly, but in the end i will be showing this data differently. I will be showing the data by company and how many times they are ranked number 1 vs number 2 etc. The slicers i want are by company and by coverage so that i can choose to only compare certain companies on certain coverages and get their summarized rankings. I hope i am explaining this well, but if not, please let me know if you have any questions.
would something like this work:
Rank:=RANKX(ALLSELECTED('Table'[RateID]),CALCULATE(SUM('Table'[Premium])))