Rank should not changes based on other fitlers

[Anonymous]

Hi,

I have Rankx based on Sales, but when I do filter in the dashboard rank value should remain display the same rank irrespective of the ay fitler selection in the dashboard.

Rank should always be based on the sales.

Is this feasible?

Thanks,

Thimma

[v-piga-msft]

Hi @Anonymous,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, could you share your Rankx formula and some data sample?

In addition, do you use Slicer to filter or visual filter in the report?

For reference, you could have a view of this similar thread.

Best Regards,

Cherry

[kaushikd]

Try this:-

=RANKX(ALL('TableName'), SUM([Number Of Rec]))

The ALL() function will take all the records from the datasource irrespective of the filters