Rank and TOPN

marcio_fornari — Thu, 30 Jul 2020 19:32:36 GMT

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 ) )

Re: Rank and TOPN

lbendlin — Fri, 31 Jul 2020 17:01:25 GMT

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

Re: Rank and TOPN

marcio_fornari — Fri, 31 Jul 2020 17:04:26 GMT

Hi lbendlin i found the problem. It was a relationship

topic Re: Rank and TOPN in DAX Commands and Tips

Rank and TOPN

Re: Rank and TOPN

Re: Rank and TOPN