Forum Discussion
how to get maximum value
- 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.
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.