I want to create a tooltip that shows a person with the most money:
The tooltip should show the following:
I imagine it has to do something with MAX function, any ideas on how to achieve this?
Go to Solution.
Hi @AndrejBI ,
give this a try:
Max Amount =
VAR _Table =
ALLEXCEPT ( 'Table', 'Table'[Fruit] ),
'Table'[Amount] = MAX ( 'Table'[Amount] )
MAXX ( _Table, 'Table'[Name] ) & " ("
& MAXX ( _Table, 'Table'[Amount] ) & "$ )"
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at homeFrankAT (Proud to be a Datanaut)
View solution in original post
Check out the News & Announcements to learn more.
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!