Forum Discussion

elle-queue's avatar
elle-queue
Frequent Visitor
2 years ago
Solved

DAX expression to count value and return the label

Hi all - I'm trying to create a DAX forumla that will return a data label (or value or category, not sure what to call it) based on the raw data below:   Winner Andy Brenda Craig Den...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

     

    1. DAX Expression to Return the Name of the Winner with the Most Wins

     

     
    MostWinsWinner = 
    CALCULATE(
    VALUES('Table'[Winner]),
    TOPN(
    1,
    SUMMARIZE(
    'Table',
    'Table'[Winner],
    "Wins", COUNT('Table'[Winner])
    ),
    [Wins],
    DESC
    )
    )

     

    2. DAX Expression to Return the Count of the Most Wins

     

     
    MostWinsCount = 
    CALCULATE(
    MAXX(
    SUMMARIZE(
    'Table',
    'Table'[Winner],
    "Wins", COUNT('Table'[Winner])
    ),
    [Wins]
    )
    )

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

1. DAX Expression to Return the Name of the Winner with the Most WinsMostWinsWinner = CALCULATE( VALUES('Table'[Winner]), TOPN( 1, SUMMARIZE( 'Table', 'Table'[Winner], "Wins", COUNT('Table'[Winner]) ), [Wins], DESC ) ) 

2. DAX Expression to Return the Count of the Most Wins

 
MostWinsCount = 
CALCULATE(
MAXX(
SUMMARIZE(
'Table',
'Table'[Winner],
"Wins", COUNT('Table'[Winner])
),
[Wins]
)
)