DAX - Find max value based on another column being filtered

Ormie

New Member
Joined
Oct 26, 2019
Messages
20
Office Version
2013
Platform
Windows
Hello,

I have a column of financial values and I want to find the MAX value of that column when a certain value appears in another column.

I tried this but without any luck.

CALCULATE(
MAX('IntCustomSearchResults'[Value of Incident],
FILTER(IntCustomSearchResults,IntCustomSearchResults[Category]="Motor")
))

Thanks,

Chris
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

JustynaMK

Well-known Member
Joined
Aug 28, 2016
Messages
628
Office Version
365, 2013
Platform
Windows
Hi Chris,

Good news is that you almost had it, you simply misplaced one bracket :)

maxMotor = CALCULATE(
MAX('IntCustomSearchResults'[Value of Incident]),
FILTER(IntCustomSearchResults,IntCustomSearchResults[Category]="Motor")
)

1580214779601.png
 

Watch MrExcel Video

Forum statistics

Threads
1,095,368
Messages
5,444,053
Members
405,264
Latest member
JohnP1972

This Week's Hot Topics

Top