How to rank columns by cost

[Bashir_Nadaf]

Hi all 

I am trying to get the rank by cost

instead of getting rank i am getting count of item no. 

Appreciate if any help!

[chrisyan_manalu]

@Bashir_Nadaf ,

Please try  =
RANKX ( ALLSELECTED ( tblUsageReportingData[ItemNo] ), [Total Cost UA], ,ASC,Dense))

[Bashir_Nadaf]

@chrisyan_manalu 
this is not working 
this measure is doubled the rank column

[v-xiaotang]

Hi @Bashir_Nadaf 

This error involves costAmount(Actual) and Total Cost UA, and we need to look at their code. If the code involves multiple tables, please share both the multiple tables and the table structure, we just need to know which fields are involved in the table.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[tamerj1]

I mean ranking itself is a measure?

[Bashir_Nadaf]

Yes @tamerj1 

ranking is a measure

[tamerj1]

@Bashir_Nadaf 
Sorry, I Have no idea why it is returning the count instead of the rank!

[Bashir_Nadaf]

ok 
thank you so much for trying @tamerj1 

[tamerj1]

@Bashir_Nadaf 

Are you using other filters or slicers?

[Bashir_Nadaf]

@tamerj1 

No not using any filters or slicers

[tamerj1]

@Bashir_Nadaf 

Are you using other filters or slicers?

[tamerj1]

Hi @Bashir_Nadaf 

please try

Rank column =
RANKX ( ALLSELECTED ( tblUsageReportingData[ItemNo] ), [Total Cost UA] )

[Bashir_Nadaf]

This is not working 

showing the same result

if i take the rank column as sum it is showing the rank as shown in above image

and if i select dont summarize it is showing 1 in rank column for all the rows

[tamerj1]

Hi @Bashir_Nadaf 
Are you sure [Total Cost UA]  is the same measure used in the visual?

[Bashir_Nadaf]

Yes 
total cost UA and cost amount(actual) are showing same data 

total cost UA is a measure and 

cost amount actual is a column

[tamerj1]

@Bashir_Nadaf 

please try remove the column from the visual and use the measure instead

[Bashir_Nadaf]

Hi @tamerj1 

added the measure and removed the column still getting the same result

[tamerj1]

@Bashir_Nadaf 
If not sensitive data, can you share the file?

[Bashir_Nadaf]

Sorry @tamerj1 

can't share..

[tamerj1]

@Bashir_Nadaf 
Please make sure you are creating a measure not a calculated column

[Bashir_Nadaf]

@tamerj1 

item no is column

cost is a measure 

ranking through cost