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 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.

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.