Forum Discussion
Solved
Show maximum value in an array
Hello, I hope you are well I need to create a measure that allows you to display the maximum value of a column. The funny thing is that this value can vary depending on the filters used. ca...
Hi Syndicate_Admin ,
You could use ALL(), ALLSELECTED() and ALLEXCEPT() function to get different result.
ALL() function could be used to calculate the max value for entire table.
https://docs.microsoft.com/en-us/dax/all-function-dax
ALLSELECTED() function could be used to calculate the max value for filtered table.
https://docs.microsoft.com/en-us/dax/allselected-function-dax
ALLEXCEPT() function could be used to calculated the max value for groups.
https://docs.microsoft.com/en-us/dax/allselected-function-dax
Best Regards,
Jay
Hi Syndicate_Admin ,
you can do it like this:
Max of selected values =
CALCULATE (
MAX ( 'Table'[number] ) ,
ALLSELECTED ( 'Table'[number] )
)With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)