Forum Discussion

jay_patel's avatar
jay_patel
Helper IV
5 years ago
Solved

how to get maximum value

hello  guys

 

looking for a dax,if i filter name "Punit" then the card should give '70' i.e, max for name. 

nametotalmins
punit30
punit50
punit70
punit10
bharat20
bharat20
bharat30
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, jay_patel 

     

    I'm not sure you need to get the desired results in table or card visual, so I've provided some of the results you might expect.

    Create a measure to use on the card:

    max = MAX('Table'[totalmins])

    Or you want to get the desired result on the table:

    max for name =
CALCULATE ( MAX ( 'Table'[totalmins] ), ALLEXCEPT ( 'Table', 'Table'[name] ) )

    You can choose the effect that suits you according to your preferences.

    The sample effect is as follows:

    Sample data:

    Result:

     

    Is this the result you want? Hope this is useful to you

    Please feel free to let me know If you have further questions

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, jay_patel 

    I am not sure if I understood your question correctly, but please check the sample pbix file's link down below.

     

    I think you can write the below measure.

    Or, if I missed something, please let me know.

     

    Result = MAX('Table'[totalmins])
     
     
     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

    Linkedin: https://www.linkedin.com/in/jihwankim1975/

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    5 years ago

    Hi, jay_patel 

     

    I'm not sure you need to get the desired results in table or card visual, so I've provided some of the results you might expect.

    Create a measure to use on the card:

    max = MAX('Table'[totalmins])

    Or you want to get the desired result on the table:

    max for name =
CALCULATE ( MAX ( 'Table'[totalmins] ), ALLEXCEPT ( 'Table', 'Table'[name] ) )

    You can choose the effect that suits you according to your preferences.

    The sample effect is as follows:

    Sample data:

    Result:

     

    Is this the result you want? Hope this is useful to you

    Please feel free to let me know If you have further questions

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.