Forum Discussion

MattN4's avatar
MattN4
Icon for Helper I rankHelper I
8 years ago

RANKX positive to Negative

Hi,   When using the RANKX formula I get a gap between postive an negative numbers. How can I overcome this?   Measure is as follows;   Rank = RANKX(ALLEXCEPT(SPER,SPER[Region]),'Sales'[Var to ...
Need Help
tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
8 years ago

Do you want to filter region by top values in Var to Target?

MattN4's avatar
MattN4
Icon for Helper I rankHelper I
8 years ago

Thanks, I can't share the pbix as it contains sensitive data.

 

Yes, there will be a filter. Basically in each region there would be several entries.

  • MattN4's avatar
    MattN4
    Icon for Helper I rankHelper I
    8 years ago

    Manged to sort it by selecting ALLSELECTED opposed to ALLEXCEPT.

     

    Thanks for your input.

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Try simply using the integrated topN filter on region with "Val to Target" in "by value"