TOPN filter dose not work as expected compared Top10 to Top15

[PbiCeo]

Hello everyone,

I use TOPN filter  for "Com" on a matrix visual.

When I use Top10 like below:

Business	Customers	Com
ABC	aa	31.48
	bb	30.45
	cc	30.43
	dd	30.38
	ee	30.30
	ff	20.10
	gg	19.50
	hh	19.20
	ii	19.18
	jj	19.14

When I use Top15 like below:

Business	Customers	Com
ABC	aa	31.48
	bb	30.45
	cc	30.43
	11	30.43
	dd	30.38
	ee	30.30
	ff	20.10
	22	20.02
	gg	19.50
	33	19.40
	hh	19.20
	ii	19.18
	44	19.15
	jj	19.14
	55	18.32

I was expecting Top1 - 10 of Top15 result would be the same.
How should I correct it?
Thanks,
Vladi

[v-jayw-msft]

Hi @PbiCeo ,

I can't see any points through the screenshot, please show more information. Something like sample data and the formula you are using would be helpful.

Best Regards,

Jay

[PbiCeo]

@v-jayw-msft 

Thank you for your reply.
Alternatively I tried to use DAX measure, Rankx with condditions using filter to then correctly filter by Topn filter, but it retuns always only 1.

RANKX(FILTER('table', 'table'[business] = 'table'[business] && 'table'[customer] =

'table'[customer]), SUMX('table', 'table'[com]))

What is wrong?
Appreciate your help, thanks in advance.

[amitchandak]

@PbiCeo has any other filter changed. I did not saw customers 11 and 22 in the first list. Can you check that.

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[PbiCeo]

Hello @amitchandak ,
Thank you for your reply.
Alternatively I tried to use DAX measure, Rankx with condditions using filter to then correctly filter by Topn filter, but it retuns always only 1.

RANKX(FILTER('table', 'table'[business] = 'table'[business] && 'table'[customer] =

'table'[customer]), SUMX('table', 'table'[com]))

What is wrong?
Appreciate your help, thanks in advance.