Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Arccc
New Member

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.      Bottom 

D.                51.      Bottom 

Where sec is a measure 

Already used calculate (max(table[data]),filter(table,[sec]="Bottom"))

Ans required is 64 

Data is weekly level ..n have filters for year and month 

 

 

 

 

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Community Champion
Community Champion

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.