Forum Discussion
Solved
Help with ranking
I have two tables Once shows the numebr fo requests by Local Authrity in England the other is the population I have a measure which divides the populaiton by the number of requests (%pop...
BCWdesign The RANKX function should be applied to a table that contains the data you want to rank, and it should reference the correct columns
DAX
Measure 3 = RANKX(
ALL('Initial Request'),
[% Population],
,
DESC,
DENSE
)Additionally, make sure that % Population is a measure that calculates the percentage of the population for each authority. If % Population is not already defined, you can create it :
% Population = DIVIDE([0-25 Population2], [Total Population])
Fantastic finally got it to work!