Power BI specific task (filter/rank/hover)

[calgarve]

Hi community,
I’m quite new with Power BI and would need to perform the below task.
I have a simple table with: ID number; Name; Type; Total
I created first treemap showing a count of Types below x ID number.
I need to create a second table showing: Name of the highest in Total for each type (still below x ID number). Ideally the top performer name would then be shown in the treemap for each type with hover (once cursor of the mouse is over a specific type).
Thanks in advance for your help.

 

[teylyn]

Hi, create a new measure on the Total column with the MAX() function. Then create a table with the name in the rows and the new measure in the values.

Showing the name with the highest total on hover of the tree map is not so easy.