Problems with RANKX and FILTER

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)

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 , 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/367415