Forum Discussion
Rankx and summarized table
I have a complex table where a column is flagged as denominator based on some variables and another column is flagged as numerator based on other criteria. Then a measure of proportion is calculated ...
Ashish_Mathur v-juanli-msft Phil_Seamark any suggestions.
Also is there a way to visualise the account catgeory based on the top 5 account names in a card/ chart visualisation.
Additionally I am using this for the best score to just show the best score as a figure without having the need for account names.
VAR Tabless = ADDCOLUMNS( SUMMARIZE(sun, sun[Account Name], sun[Territory]), "Scores", [Current %], "Ranks", [Rank])
RETURN
MINX( Tabless, [Scores])
See using what I have the measure is still ranking an entity that has denominator less than 10.
Also please see top 5 table works fine but when territory is introduced it goes haywire
And it does not show just the top 5 anymore but starts showing all entities even though the measure uses top 5
Perhaps you need to use nested interators to ensure values are calculated on the right level.
