_Dynamic text from a measure

[Raul_Cristobal]

Hello, I want to place the text on a card depending on the size. For example: in this case the max is 54 and on another card I want to place the text (Equipo: 'Hemobascula').

Ty.

[Anonymous · Accepted solution]

Hi @Raul_Cristobal ,

Please try this:

Measure = 
VAR _table = SUMMARIZE('TableName','TableName'[EQUIPO],"Qty",[Qty PREVENTIVOS])
VAR _qty_max = MAXX(_table,[Qty])
VAR _result = MAXX(FILTER(_table,[Qty]=_qty_max),'TableName'[EQUIPO])
RETURN
"Equipo:" & "'" & _result & "'"

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum