Forum Discussion
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...
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]
)
)
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]
)
)
Thank you so much - you've saved me so much time 😁
No worry's I had a problem for myself and i know how Power BI is