RANKX with Measure in blows up table visual

[Anonymous]

Hi Folks ,

I have a data model as follows:

I would like to create a Rankx measure to rank based on [NewSort2] and the 'StationUtilTable'[Average Station Util] . When i included the measure it  blows up the table visual like so:

I know i am getting the row context wrong, my Ranking measure is as follows:

MultipleRanking =

var var1=ALLSELECTED(EquipUtilTable)

return RANKX(var1,

                     RANKX(var1,CALCULATE([NewSort2]),,DESC,Dense)

                        + DIVIDE(RANKX(var1,CALCULATE(MIN(StationUtilTable[StationUtil])),,DESC,Dense),COUNTROWS(var1)+1)

                             ,,,Dense)

What have i done wrong and how to correct it? The Pbi link is here for your reference
Thanks in advance!

[amitchandak]

@Anonymous , In case you need to combine rank, you can have more than one column

example

City and ID Rank = RANKX(all(Geography[City],Geography[City Id]),[Sales])

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415