Ranking column based on RLS

shubhamc_002 — Tue, 28 Mar 2023 15:44:57 GMT

HI Team,

We have one requirement in which ranking of product ID should be decided even after applying RLS also.
Consider below table (Raw data), In this table Calculated COlumn having rankX measure applied based on ID column

Product ID	Product Name	Calculated Column(Rank)
1	A	1
2	B	2
3	C	3
4	D	4
5	E	5

Requirement is to generate below output after RLS applied(RLS is applied on Product ID. Based on User acces Product ID will be filtered from dataset).

Product ID	Product Name	Calculated Column(Rank)
1	A	1
3	C	2
5	E	3

Unfortunatly if we are using RANKX measure it is giving us same ranking which was calculated before . for above table it will show 1,3,5 even in calculated Column(Rank) as well.

Can you please let us know if any way to solve this .

DAX measure used for calculated column
RANKX( 'Product','Product[Product ID],,ASC)

Thanks

Re: Ranking column based on RLS

wdx223_Daniel — Wed, 29 Mar 2023 07:35:48 GMT

calculated column can not get outside filters. it's ok in visual page

topic Re: Ranking column based on RLS in DAX Commands and Tips

Ranking column based on RLS

Re: Ranking column based on RLS