How to return group name of maximum value? DAX

[Anonymous]

Hello,

I am relatively new to Power BI so my apologies if this has been answered. I have not been able to stumble across a similar thread.

I am working on creating a visual and in the tooltips I want to display the group with the most occurrences. Below are two screenshots of the visuals I am working with. The stacked column chart is where I would like to display the tool tip, and the Table is illustrating the value I'd like to display within the tooltip.

So when I would hover over one of the columns, I am able to display the max value for that column with the below DAX code. However, I would like to display the Group that holds that max value. So if I hovered over a column and the max value for that column happened to be 27, the tooltip would display A.

Group Count = 

COUNTX (

    FILTER ( tableName, EARLIER ( tableName[Group] ) = tableName[Group && tableName[Group] = 'SomeValue' ),

    tableName[Group]

)

Group	Num Occurrences
A	27
B	27
C	25
D	24
E	22
F	17

Any help and/or suggestions would be appreciated.

Thank you

[lbendlin]

You may need to use a custom tooltip page for that.  Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

[Anonymous]

Thanks - I have updated to include sample data.