topic Re: How to find Max value in dax in Developer

How to find Max value in dax

Arccc — Sat, 13 Nov 2021 11:57:49 GMT

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

Re: How to find Max value in dax

Greg_Deckler — Sat, 13 Nov 2021 12:45:51 GMT

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