Solved: TOP N in DAX - Page 2

Jaweed · ‎11-29-2019

Hello friends

I would like to display the count of TOP 3 count of Staff. I cannot get it right.

My table is as below

John

Rob

Bill

Alex

Sam

Dough

I would like a table visual to show top 3 count of staff - Only these 3 to be displayed

Name Count

John 4

Rob 4

Bill 2

Appreciate some help. Thanks.

az38 · ‎11-29-2019

add measure

r = rankx(ALL('Table'[Name]);calculate(COUNT('Table'[Name]));;;Skip)

Next, in the visual filter pane set "r is less then 4"

do not hesitate to kudo useful posts and mark solutions as solution
Linkedin

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

TOP N in DAX