Formula to sum all sales with Max and all sales with Min price

[Anonymous]

Hello 

I am trying to report price elasticity in PowerBi.  I looked at posts and and used this formula for the qty at min price

Qty Min Price = CALCULATE(SUM('Total Fuel Sales'[Qty]),FILTER(VALUES('Total Fuel Sales'[Price/Gal]),MIN('Total Fuel Sales'[Price/Gal])= [Min Price]))

It give me the quantity of just one sale at the min price instead of summing qty for all sales at that price.

What formula will give me the sum?

BTW: The Total Fuel Sale table has with a row for each sale

[v-chuncz-msft]

@Anonymous 

You may try using SUMMARIZE Function inside the SUMX Function.

https://community.powerbi.com/t5/Desktop/Show-Top-N-values-only-in-a-new-table-monthly-average-of-daily/m-p/233772#M104113

[Anonymous]

Could you give me an example with the following 

Product	Region	Date	Invoice	Qty	Price/Gal
Jet Fuel	GLN	1/1/2019	12	100	$      1.00
Jet Fuel	GLN	2/1/2019	42	100	$      1.00
Jet Fuel	GLN	1/12/2019	13	20	$      2.00
Jet Fuel	Jax	2/12/2019	14	20	$      1.00
Jet Fuel	Jax	1/12/2019	15	30	$      2.00
Gas	GLN	1/1/2019	16	40	$      1.00
Gas	GLN	2/12/2019	17	50	$      2.00
Gas	Jax	2/12/2019	18	60	$      1.00
Gas	Jax	2/12/2019	44	200	$      1.00
Gas	Jax	1/12/2019	19	70	$      2.00
Expected Results
Slicers: Jet Fuel and GLN and 2019
Qty at min price	200
Slicers: Jet Fuel all regions and 2019
Qty at min price	220
Slicers: Gas and Jax and 2019
Qty at min price	260
Slicers: Jet Fuel and GLN and Jan 2019
Qty at min price	100

[Anonymous]

I am sorry to say I don't understand how to use the summarize for this... or any solution. I am new to DAX.  I read the Mircorsoft explanation but still puzzled. I just watned to respond since you were kind to answer. 🙂