Rank based on KPI

adias102 — Thu, 22 Apr 2021 12:32:53 GMT

Hi,

I have an application that shows several measures for departments.

The basic display shows all the data for a chosen department (only 1). All the data is KPIs and I calculate several grades for each department and a final grade.

G1 - total sales for this department relative to max sales, value between 0 to 100.

G2 - total expenses relative to max expensesת value between 0 to 100.

G - G1 * 0.6 + G2 * 0.4.

Now I want to add a KPI to display the rank of this department based on G.

If I use a table and show all the departments then the rank measure is workung fine.
If I choose one department then the rank shows 1.

How can I ignore the chosen dimension value? I read many threads but I don't use a sum function or something like it to add a set analysis.

topic Rank based on KPI in App Development

Rank based on KPI