DAX Top 1 Name

[ajay_gajree]

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?

[harshnathani]

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

[baghdadi62]

Hi,

use this measure:

Measure_1 = CALCULATE (
    MAX ( Table[Social_Name] ),
    FILTER (
        VALUES ( Sheet1[Share] ),
        RANKX ( ALL ( Table[Share] ),Table[Share],, DESC ) = 1
    )
)