Rank Function Error

[Recoil]

Hello everyone,

I am having a problem with the Rank function in a Report Table Visualization.  I have a simple table on a canvas.  It is reading from my table 'Data' and contains one column for Contract State and another column for "Absolute DnU Value" which is formatted as Currency.  

In the table, I am trying to rank the States with the highest "Absolute DnU Value" so I added a new measure with the formula below but it is giving me all 1's in the rank column.  If at all possible, would someone please help me to understand what I am doing wrong?   I greatly appreciate your time!

Rank = Rankx(All('Data'),Sum(Data[Absolute DnU Value]))

I even tried

Rank = Rankx(ALLSELECTED('Data'),Sum(Data[Absolute DnU Value]))

[GilbertQ]

Hi @Recoil 

You have to include the column name in your RANKX for it to work correctly.

This should work

Rank = Rankx(ALLSELECTED('Data'[Contract State]),Sum(Data[Absolute DnU Value]))

[Recoil]

@GilbertQ Thank you so much for responding/helping!!!! It is tremendously appreciated!

When I make that edit, the Ranking still does not produce.  Please see below.

[GilbertQ · Accepted solution]

Hi @Recoil 

Could you first create a measure for your "Absolute D&U Value"

Then use this measure in both your table and RANKX as shown below.

New Measure 

DnU Value = SUM('Data'[Absolute D&U Value])

Rank = Rankx(ALLSELECTED('Data'[Contract State]),[DnU Value]))

[Recoil]

@GilbertQ That worked!   Could you explain to me why that had to be done so that I know for next time?

[GilbertQ]

Hi @Recoil 

What happens when you have the SUM inside of the RANKX it cannot compare with the overall values to rank it. 

[Recoil]

Thank you so much for your time and expertise!!!  I greatly appreciate your time.