Rank and TOPN

[marcio_fornari]

Hi,

 I have one DAX Function called TOPN and it works perfectly, show me the TOP5

But when i use the Date Filter the sales column works, the Rank Works,  but the TOPN returns Blank.

My Measures RANK and TOPN 

Ranking Ticket Medio Procedimentos = 
IF([Ticket Medio Fat. Proced],
    RANKX(
        ALL(D_TIPO_PROCEDIMENTO[nome]),
        [Ticket Medio Fat. Proced]
    )
)

TOP N Ticket Médio Procedimentos = 
var topNSelecionado = SELECTEDVALUE('TopN'[N],5)
return
CALCULATE(
    [Ticket Medio Fat. Proced],
    FILTER(
        VALUES(D_TIPO_PROCEDIMENTO[nome]),
        [Ranking Ticket Medio Procedimentos] <= topNSelecionado
    )
)

[lbendlin]

None of the transactions for the selected day are in the Top 5.

[marcio_fornari · Accepted solution]

Hi @lbendlin i found the problem. It was a relationship