TOPN not working

DAX
1

Good day Team,

i am having an issue with trying to use TOPN through the filter pane. i need to filter on 2 columns

image

  1. Rating which needs to return the highest ratings
  2. Count of ratings which needs to sort highest to lowest.

The Dax i have used is

Rating =
MAXX(
VALUES(‘Observed Competency’[Competency Localized]),
MAX(‘Observed Competency’[Score])
)

Count of rating =
COUNTROWS(
FILTER(
‘Observed Competency’,
‘Observed Competency’[Score] = [Rating]
)
)

TOPN filter is as per below

image

2

this no longer needed, we can close the ticket