how to get maximum value

[jay_patel]

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
bharat	20
bharat	30

[v-angzheng-msft · Accepted solution]

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.

[Jihwan_Kim]

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])

https://www.dropbox.com/s/um2aye0h4tqdia3/jaypatel.pbix?dl=0 

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/