Show Top 2 Rows without affecting Percentage

[Anonymous]

Hi All,

I have a table as below.

Country	Market Value	AUM
UK	23	12
US	45	45
HK	87	34
SG	34	67

I want to show both the columns as 'Show values as Percent of Grand Total'. I got the values as below in Power BI.

Now I want to show only Top 2 rows based on the highest Market Value by Country. Now if I apply Top N condition, the percentage values gets changed as below, may I know if there is a way to show top 2 rows as it is and not getting changed.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

All measures are written in the attached pbix file.