Forum Discussion

Arccc's avatar
Arccc
New Member
4 years ago
Solved

How to find Max value in dax

Hi , I am new to dax ...I want to find Max value of data that looks like below.  Category.   Data.  Sec A                 50.     Top  B                 53.      Bottom C.                64.    ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Arccc Not sure of what your Sec measure formula is, mine is Measure 15 in the formula below:

    Measure 16 = 
    VAR __Table = 
        FILTER(
            ADDCOLUMNS(
                SUMMARIZE(
                    'Table16',
                    [Category],
                    "__Sum",SUM('Table16'[Data])
                ),
                "__Sec",[Measure 15]
            ),
            [__Sec] = "Bottom"
        )
RETURN
    MAXX(__Table,[__Sum])
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Arccc Not sure of what your Sec measure formula is, mine is Measure 15 in the formula below:

Measure 16 = 
    VAR __Table = 
        FILTER(
            ADDCOLUMNS(
                SUMMARIZE(
                    'Table16',
                    [Category],
                    "__Sum",SUM('Table16'[Data])
                ),
                "__Sec",[Measure 15]
            ),
            [__Sec] = "Bottom"
        )
RETURN
    MAXX(__Table,[__Sum])