Forum Discussion

stevejames's avatar
stevejames
Advocate I
1 year ago
Solved

Rank X issues

I've got a RANKX solution working in a situation where a visual showing all "areas" for a single "category" I'm now trying to show a visual with all "categories" but for a single "area" and want t...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi,

    Thanks for the solutions Bibiano_Geraldo  and DataNinja777  offered, and i want to offer some moreinformation for user to refer to.

    hello stevejames , you can try the following.

     

    Cost per head rank = 
RANKX(
    FILTER(
        ALLSELECTED('Costs'), [AreaName] in values( 'Costs'[AreaName])
        'Costs'[Total]<>0 && NOT(ISBLANK('Costs'[Total]))
    ),    
    CALCULATE([Cost per head]),
    ,
    DESC,
    DENSE
)

    If the information cannot help you can you provide some sample data?

     

     

    Best Regards!

    Yolo Zhu

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

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Super User
1 year ago

Hi stevejames ,

have your tried using ALL function?

Cost per head rank =
    RANKX(
        FILTER(
            ALL('Area'[Name]),  -- ignores the current filter on Area
            'Costs'[Total] <> 0 && 'Costs'[Total] <> BLANK()
        ),
        CALCULATE([Cost per head]),
        ,
        DESC,
        DENSE
    )