How to change a ranking measure to column

[larcaris]

Hello everyone!

I need a help. I did a ranking measure that from of other measure (F_Total), but in fact i need to change this ranking measure to  column, to use it as category in my graph later on.

My ranking measure is: 

Ranking_E = RANKX(ALL('Tabela_Append'[Dim_DePara_Full.GPO Category PBI]), [F_Total], , DESC, Dense)

Any help is appreciated, thank you so much!

[v-kelly-msft]

Hi @larcaris ，

You need a calculated column as below:

Rank = 
RANKX (
    CALCULATETABLE ( DISTINCT ( 'Table'[Category] ), ALLSELECTED ( 'Table' ) ),
    CALCULATE (
        SUM ( 'Table'[F-Sales] ),
        FILTER (
            ALLSELECTED ( 'Table'[F-Sales] ),
            'Table'[Category] = EARLIER ( 'Table'[Category] )
        )
    ),,
    ASC
)

Then you will see:

For the related .pbix file,pls click here.

Best Regards,
Kelly

[larcaris]

Hello @v-kelly-msft  Kelly!! You are so helpful!.

But i need to open the problem. In my real case, the F-Sales is a measure (that was migrated from excel). My goal is to do a column ranking, and later on a column with TOP5 os these ranking.

I will send the pbix file with notations and example of my real case, i would be glad your help or suggestion, because im in the problem for 1 month :((

For pbix, click here ! 

Thank you so much!

[larcaris · Accepted solution]

Resolved with measure!

First, i created a index measure, based on ranking that already works, where i can to set the number of the index that i want to show at waterfall graph.

Index =

IF(

[Ranking_] <= 5,

[Ranking_],

if(SELECTEDVALUE(Dimension_[Category])="X",0,

if(SELECTEDVALUE(Dimension_[Category])="Y",7,

if(SELECTEDVALUE(Dimension_[Category])="OTHERS",6))))

In the graph, i've added Index measure as a tooltip, and then, order the graph based on my index measure, and it worked perfectly!!!!!!!

[amitchandak]

I think You are creating it on the measure, so it needs to be a measure. Why are you not able to use this measure in the graph