TopN based on % or dynamic measure?

[Anonymous]

Is this possible? I need the top10% of a value not a set whole number. I tried to create a measure and use that in the TopN dax formula but am receiving an error

I also tried this formula

[BrianConnelly]

You didn't provide what [10% Distinct Owners] is, but I assume you have a slicer to show TOP number to show and a table with Opportunity Owners.  If so, try the following...

Net Sales Ranked:=
IF (
    ISINSCOPE ( 'RevRec'[Opportunity_Owner_Name] ),
    VAR OwnersToRank = [TopN]  -- Can Use Selected Value or hardcode, e.g 10
    VAR SalesAmount = [Sales Amount] -- OR SUM('RevRec'[Net Revenue])
    RETURN
        IF (
            SalesAmount > 0,
            VAR VisibleOwner =
                CALCULATETABLE (
                    VALUES ( 'RevRec' ),
                    ALLSELECTED ( 'RevRec'[Oportunity_Owner_Name] )
                )
            VAR Ranking =
                RANKX (
                    VisibleOwner,
                    [Sales Amount],
                    SalesAmount
                )
            RETURN
                IF (
                    Ranking > 0 && Ranking <= OwnersToRank ,
                    Ranking
                )
        )
)