Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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