Forum Discussion
Ranking in Matrix
Hi All - I'm working on a Matrix Visual that contains multiple KPIs for states. The table needs to have the rank of the KPI against all other states. For example: User filter: North Caroli...
Hi,
you use only one formula for all KPIs? it is needed to use Matrix Visual
I think we use function Rankx():
rank = RANKX(SUMMARIZE(table,state column),formula KPI)
| 2022 | 2021 | Total | ||||
| KPI | Rank | KP | Rank | KP | Rank | |
| GSP | - | - | - | - | - | - |
| HPI | - | - | - | - | - | - |
| Unemployment | - | - | - | - | - | - |
| CPI | - | - | - | - | - | - |
The Matrix seem like that if you add rank column