topic Re: How to calculate the MAX of a total of a group of columns in DAX Commands and Tips

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

andyly85 — Sun, 14 May 2023 12:27:23 GMT

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

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

maeshakib — Sun, 14 May 2023 13:40:16 GMT

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

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

tamerj1 — Sun, 14 May 2023 14:27:45 GMT

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