All Time High and Low based on multiple Fields and Date

[JKPBI]

Hello all:

I am trying to figure out how to get an ATH measure based on a couple of fields. BAsiclaly the data is structured like below (with many other columns, but not of concern), and I'd like to get measures that produce the ATH or ATL. 

I'll likely have some filters going on for Set, in case that makes a difference.

EDIT: as additional info: What I'm looking for it to do is compare the Totals for each date and then return which of those was highest. It would therefor have to SUM up the totals by Date for all different Variety (per each date) and then return whichever one was highest.

So would SUM Green, Red, and Blue for 1/5/2022 and compare to the SUM of Green, Red, and Blue for 2/5/2022.

Set	Variety	Date	Total
Set 1	Green	1/5/2022	$  100.00
Set 1	Green	2/5/2022	$  110.00
Set 1	Green	3/5/2022	$    90.00
Set 1	Red	1/5/2022	$    20.00
Set 1	Red	2/5/2022	$    10.00
Set 1	Red	3/5/2022	$       5.00
Set 1	Blue	1/5/2022	$  800.00
Set 1	Blue	2/5/2022	$  950.00
Set 1	Blue	3/5/2022	$  700.00

Set 1 ATH	$  1,070.00
Set 1 ATH Date	2/5/2022
Set 1 ATL	$     795.00
Set 1 ATL	3/5/2022

Thank you to anyone that gives advice, I appreciate it

[SpartaBI]

@JKPBI maybe more info is required in case total is a column in your table then try this:
Set 1 ATH = CALCULATE(MAX('Table'[Total]), REMOVEFILTER('Table'), VALUES('Table'[Set])
Set 1 ATL = CALCULATE(MIN('Table'[Total]), REMOVEFILTER('Table'), VALUES('Table'[Set])

Showcase Report – Contoso By SpartaBI

      

[JKPBI]

@SpartaBI 

Thank you for the response. I think I can provide some extra information:

What I'm looking for it to do is compare the Totals for each date and then return which of those was highest.

It would therefor have to SUM up the totals by Date for all different Variety (per each date) and then return whichever one was highest.

So would SUM Green, Red, and Blue for 1/5/2022 and compare to the SUM of Green, Red, and Blue for 2/5/2022.

[SpartaBI]

@JKPBI I will PM you