TOP N

[xariet]

I have the following calculation for the top N projects

Top N Projects =

VAR SelectedTop = SELECTEDVALUE('Top N'[Top N])

RETURN

SWITCH(TRUE(),

    SelectedTop = 0, [Revenue],

    RANKX (

            ALLSELECTED(  'fin fact'[dim project key]),

            [Revenue]

                )

                  <= SelectedTop,

        [Revenue]

)

Table 'fin fact' is connected to the 'Project dim' table  by the  [dim project key].  So when I bring to the table  [Top N Projects] and [dim project key] it is filtering just fine with the TopN slicer. But if I want to bring [Progect Name] from the 'Project dim' table , my viz breaks and do not filter by top N slicer anymore. What am I missing in the calculation? The Tables connected correctly 

[amitchandak]

@xariet , Please consider TOPN and window

Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ