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.  name totalmins punit 30 punit 50 punit 70 punit 10 bharat 20 ...
  • v-angzheng-msft's avatar
    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.