Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Card value based on another column

Hi there,

 

I want to show in a card the name of the client who earned the most in a date range. I have these two tables which are DirectQueries. 

 

I know it surely is obvious for a lot of you, but I'm still in process of learning the basics.

 

Is there any way I can do it? Any help or advice would be kindly appreciated!

 

 

 

COD_CLIENTNAME
1Jack
2Louise
3Frank
COD_CLIENTEARNINGS
2$4,879.03
1$271,88
3$89,764
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Please Try This measure
    _name =
    VAR  _MAX =
    MAX ( 'Table_name(1)'[_CLIENTEARNINGS] )
    VAR MAX_NAME =
    CALCULATE (
    MAX ( 'Table_name'[_CLIENTEname] ),
    FILTER ( 'Table_name', 'Table_name(1)'[_CLIENTEARNINGS] = _MAX )
    )
    RETURN
    MAX_NAME

  • truptis's avatar
    truptis
    4 years ago

    Hi Anonymous,

    Please try this:
    Result = var max_earning = max('tablename'[CLIENTEARNINGS])
     RETURN 

    CALCULATE (
    MAX ( 'Tablename'[CLIENTNAME] ),
    FILTER ( 'Tablename', 'Tablename'[CLIENTEARNINGS] = max_earning )
    )

    Anonymous - Please mark it as a solution, if it helps you. Thanks. 

     

    Regards,

    TruptiS

2 Replies

  • truptis's avatar
    truptis
    Community Champion
    4 years ago

    Hi Anonymous,

    Please try this:
    Result = var max_earning = max('tablename'[CLIENTEARNINGS])
     RETURN 

    CALCULATE (
    MAX ( 'Tablename'[CLIENTNAME] ),
    FILTER ( 'Tablename', 'Tablename'[CLIENTEARNINGS] = max_earning )
    )

    Anonymous - Please mark it as a solution, if it helps you. Thanks. 

     

    Regards,

    TruptiS

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Please Try This measure
    _name =
    VAR  _MAX =
    MAX ( 'Table_name(1)'[_CLIENTEARNINGS] )
    VAR MAX_NAME =
    CALCULATE (
    MAX ( 'Table_name'[_CLIENTEname] ),
    FILTER ( 'Table_name', 'Table_name(1)'[_CLIENTEARNINGS] = _MAX )
    )
    RETURN
    MAX_NAME