Rank is getting Skipped

[kunalkawalee]

Hi , 

I am trying to create a vendor Rank based on the purchase order amount. 

which would be dynamic based on the date filter selected. 
This is the dax I am using. 

VendorRank =

Rankx(all('Dim Vendors'),[$ PO Amount],,ASC,Dense)

but its is skipping the ranks. 

for example :- 

Purchase Amount	rank	Vendors
$20.00	2	A
$95.75	4	B
$268.00	8	C
$197.44	8	D
$207.00	8	E
$363.00	11	F

can anybody please help me why is this happening and how to resolve this. ?

[ahmedoye]

This mostly depends on what is in the measure [$PO Amount]. So you will need to check other alternatives to write the same measure and see if it solves the problem.

If this answer works for you, kindly mark as solution so others with similar issues can easily find the solution.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file and show the problem there clearly.

[v-xinruzhu-msft]

Hi @kunalkawalee 

Did thr solution danextian  offered help you solve the problem, if it helps, you can consider to accept it as a solution so that more user can refer to, or if you have other problems , you can offer some information so that can provide more suggestion for you.

Best Regards!

Yolo Zhu

[danextian · Accepted solution]

Hi @kunalkawalee 

Since you're using Dim Vendors, I am assuming there is a separate  fact table which $ PO Amount is based on and each vendor has a single record in the Dim Vendors table.

Rank Test = 
RANKX ( ALL ( 'Dim Vendors' ), [PurchaseAmount],, ASC, DENSE )

PurchaseAmount = 
SUM ( Purchases[PurchaseAmount] )

Now, looking at your sample data, why arent you using $ PO Amount in your table and is  Purchase Amount aggregated?