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.