Philip Seamark explains how the RANKX function works:

One of the first traps to encounter when using this function is the function can be used in calculations for

calculated columnsas well ascalculated measures. The RANKX function will still do what it is asked. The trick is how you use the function in each scenario – and more importantly, what filters are going to be implicitly applied to the data the RANKX function actually uses.

This is a helpful post for explaining the ranking function.

Kevin Feasel

2018-03-06

Power BI