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.

[v-rzhou-msft · Accepted solution]

Hi @Raul_Cristobal ,

Please try this code to create a measure.

Equipo of max =
VAR _TABLE =
    SUMMARIZE (
        ALLSELECTED ( 'TABLENAME' ),
        'TABLENAME'[EQUIPO],
        "SUM", [Qty M_Preventivo],
        "MAX", [MAX Equipo Preventivo]
    )
RETURN
    MAXX ( FILTER ( _TABLE, [SUM] = [MAX] ), [EQUIPO] )

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Raul_Cristobal , You can use TOPN

Maxx(TOPN( 1, ALL(Table[DES_EQUI_PO]), [Qty MPrevinto], DESC), [DES_EQUI_PO])

Use correct measure and table