how to auto filter the other values on the same table based on the Top n measure in power bi

[RanjanThammaiah]

Hi All,

may i know if i can get suggestion on how to filter the TOPN value along with other fields on the table.

it's working perfectly with TOPN with one field used for TOPN

if i add any other value field then it's not working.

TopN PL =

VAR SelectedTop = SELECTEDVALUE('Parameter 2'[Parameter])

RETURN

SWITCH(TRUE(),

SelectedTop = 1, [1.TVPS],

RANKX (ALLSELECTED('S&P-Open'[PursuitLeaderName]),[1.TVPS])

<= SelectedTop,[1.TVPS])

[v-shex-msft · Accepted solution]

HI @RanjanThammaiah,

AFAIK, measure expressions are calculated based on current row and context group. The operation to add new fields to visual should break the current row context aggregation and may affect the formula calculations results.

Row Context and Filter Context in DAX - SQLBI

If you do not want these affect the calculation, you can try to add all functions to ignore the specific filters.

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

Regards,

Xiaoxin Sheng