Forum Discussion

stevejames's avatar
stevejames
Icon for Advocate I rankAdvocate 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.

stevejames's avatar
stevejames
Icon for Advocate I rankAdvocate I
1 year ago

Thanks for that....
My logic is that I need to rank areas within the context of the specific category.
ie within Category X; Area 1 is ranked 3 of 15.
Within Category Y; Area 1 is ranked 1 of 15.

I like the look of your debug measure as that may help lots to understand what it is actually ranking.
Thanks for that.......

Anonymous's avatar
Anonymous
Not applicable
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.