Consistent Ranking Measure Ignoring Page Slicers

Hi mbanchik ,

Thanks for the reply from samratpbi , please allow me to provide another insight:

Instead of measure, you could try using a calculated column.

Develop measure values for dynamic calculations that change based on user actions such as filtering or slicing. This way, you can use the same measure values for different visual objects and data sections.

Unlike measure values, calculated columns are not dynamic; they are calculated only once when the table is first loaded or refreshed; this occurs during a query. As a result, calculated columns provide static values that don't change based on the filter context, making them more predictable and easier to understand in some cases.

Therefore, you can try to use calculated columns to avoid the result of an expression changing because of a change in the slicer.

More detailed information can be found at the link:

Understanding Measures vs Calculated Columns in Power BI (gorilla.bi)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.