How to calculate the MAX of a total of a group of columns

[andyly85]

Hi all,

How do I create a measure to pull the max and min total of each the columns below (to use as a card visual).  Max steps-Andy Ly 68316 in this case.  Thanks in advance

[tamerj1]

Hi @andyly85 
I'm not sure why are you creating a measure for each name. You can simply use a matrix visual, place [Day] at the rows of the matrix, place [Name] at the columns of the matrix and place the following measure in the values of the matrix (it assumes that the required calculation is a simple sum but you need to modify based on your real requirement). The same measure can be placed in a card visual to identify the max value requested.

Result =
MAXX (
    SUMMARIZE ( 'Table', 'Table'[Name], "@Value", SUM ( 'Table'[Value] ) ),
    [@Value]
)

[maeshakib]

Just Create two measures for every column. and user Min and Max function.