Forum Discussion

Raul_Cristobal's avatar
Raul_Cristobal
Regular Visitor
3 years ago
Solved

_Dynamic text from a measure

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.

Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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