Forum Discussion

Sri_phani's avatar
Sri_phani
Icon for Helper III rankHelper III
2 years ago

Ignore RLS and get the rank

Hi,  I have Employee-wise RLS on the Active agent's table, but I have a separate table called All metrics that has KPIs (1-1 relationship). Now when I applied RLS the ranks show as 1. This is expect...
Sri_phani's avatar
Sri_phani
Icon for Helper III rankHelper III
2 years ago

lbendlin How do I incorporate Crossfilters in this measure? 

 

Team rank =
VAR table_ =
ADDCOLUMNS(
  FILTER(
    all('All Metrics'[Employee Name],
       'All Metrics'[Supervisor 1 (Team Manager) ]),
           'All Metrics'[Supervisor 1 (Team Manager)] = MAX('All Metrics'[Supervisor 1 (Team Manager) ])
           ),"attain", 
    [Resolve Attainment]
)
Return
Format(rankx(table_,[Resolve Attainment],,desc,Dense), 0)&"/"&COUNTROWS(table_)

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

use CALCULATETABLE instead of FILTER