Get Top N Highest Value for duplicate records

[Krishnan_47]

Hi All,

I have the following Data loaded into Power BI. 

Country	Currency	Value
Australia	USD	100
Singapore	SGD	90
Malaysia	USD	80
NZ	NZD	70
Australia	AUD	60
Malaysia	MYR	50
Australia	AZD	60

I want to display Top 3 Country by Value in desc order. I have applied Top N filter condition as shown below but I am not getting the desired result. This is because in Country Column, Australia and Malaysia values are repeated due to different Currency column. Is there a way to get only the Top 3 rows? Thanks.

[ryan_mayu · Accepted solution]

@Krishnan_47 

you can create two measures

_value = sum('Table'[Value])

Measure = RANKX(all('Table'),[_value],,DESC)

and add measure to the filter