Problems with RANKX and FILTER

[Arlenio]

Hi guys, could you help me?

I want to rank some data, but I'm having problems.

I want him to NOT consider rank values ​​greater than 100 and less than 0. However, he is classifying values ​​greater than 100 as First. How to fix this and put them in last?

[amitchandak]

@Arlenio , create a measure that does not have value above 100 and then try.

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/3...

[Arlenio]

Hi guys, here its how a solved the problem

[harshnathani]

HI @Arlenio ,

Not sure what id the end objective and very difficult to help you without the sample pbix.

Try this.

RANK =
VAR _roe = [ROE]
RETURN
    RANKX (
        FILTER (
            ALLSELECTED ( 'dAcoesSiglas' ),
            _roe < 100
                && _roe >= 0
        ),
        _roe,
        DESC,
        DENSE
    )

Regards,

HN

[Arlenio]

I tried here, but with no success. I can send you the file by whatsapp or something like that.. could you help me?

or by email if you want.

This is the result with your dax formula

[harshnathani]

Hi @Arlenio ,

Try like this.

RANK =
RANKX (
    ALLSELECTED ( 'dAcoesSiglas'[Papel] ),
    [ROE],
    ,
    DESC,
    DENSE
)

Then in Filter this Visulaization 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Arlenio]

I cannot put it in the visualization filter because for other measurements I will need all the data. would you have any more suggestions?