Filtering the Report defaults RANKX and it just show just 1

[roshenrrujj]

Hi all, is there a way to make RANKX to show the right rank in overall data even after filters applied? 

this is my data sample. 

Job	Contractor	Contractor Payment	State	Region	Town	Work Started	Work Ended
8439750	1086	$10,329.26	QLD	QLD Rural	Rockhampton	14/03/2023
8441239	1126	$82,135.70	QLD	QLD Rural	Rockhampton	1/03/2023
9909507	1148	$4,020.85	NSW	NSW Rural	Tweed Heads	3/05/2023
8438720	1198	$4,042.37	QLD	QLD Rural	Rockhampton	3/02/2023	30/03/2023
8438720	1198	$10,501.92	QLD	QLD Rural	Rockhampton	3/02/2023	30/03/2023
8439750	1198	$24,447.44	QLD	QLD Rural	Rockhampton	12/04/2023
8450245	1198	$199,771.46	NSW	NSW Rural	Tweed Heads	6/04/2023
8450432	1305	$43,029.86	TAS	TAS	Hobart	24/05/2023
8444572	1484	$253,608.70	QLD	QLD Rural	Rockhampton	16/02/2023
9906018	1649	$8,329.19	VIC	VIC Metro	Melbourne	8/03/2023	23/05/2023
8454213	1655	$75,492.70	VIC	VIC Rural	Albury/Wodonga	1/05/2023
60101349	1743	$913.68	VIC	VIC Metro	Melbourne	12/01/2023	12/01/2023
8452116	1824	$15,431.13	SA	SA	Adelaide	12/05/2023
8452263	1824	$23,402.84	WA	WA	Perth	5/05/2023
8442947	1832	$169,773.98	VIC	VIC Metro	Melbourne	25/01/2023
8453700	1832	$118,862.25	VIC	VIC Rural	Bendigo	27/02/2023
8445412	1869	$79,651.77	QLD	QLD Rural	Rockhampton	6/04/2023
9908698	1918	$2,904.14	QLD	QLD Metro	Brisbane	28/02/2023
9908698	1918	$1,920.60	QLD	QLD Metro	Brisbane	28/02/2023

my RANKX:

RANK = RANKX(ALLSELECTED(DATA[Contractor]), [Avg Payment])

result:

but when i filter the table, lets say to contractor=1824, instead of 8, i get 1

can someone please help me to come up with a DAX query that would produce the original RANK even after the filtering applied? 

thanks.  

[johnt75 · Accepted solution]

Instead of ALLSELECTED you need to use ALL

My Rank = RANKX( ALL('Table'[Contractor]), [Avg Payment] )

[roshenrrujj]

thank you so much! worked perfectly!