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
