Forum Discussion

ajay_gajree's avatar
ajay_gajree
Icon for Helper I rankHelper I
6 years ago

DAX Top 1 Name

Hi all

If I have a table like

Channel. % Share Of Mentions
FB. 25
Insta. 35
Twitter. 40

Where % Share of Mentions is a written Measure, how do I write some DAX to return Twitter as the top channel based on that measure?
DAX Calculation
help in dax Function

2 Replies

  • baghdadi62's avatar
    baghdadi62
    Icon for Resolver III rankResolver III
    6 years ago

    Hi,

    use this measure:

    Measure_1 = CALCULATE (
    MAX ( Table[Social_Name] ),
    FILTER (
        VALUES ( Sheet1[Share] ),
        RANKX ( ALL ( Table[Share] ),Table[Share],, DESC ) = 1
    )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi ajay_gajree ,

     

    Create a Measure =

     

    RANKX( ALL('Table'[Channel]), [%Share of Mention] , ,DESC)

     

    Then put a visual filter on rank=1

     

    Regards,

    Harsh Nathani