cancel
Showing results for
Did you mean:
Frequent Visitor

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

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
3 REPLIES 3
Community Support Team

## Re: Formula to sum all sales with Max and all sales with Min price

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

## Re: Formula to sum all sales with Max and all sales with Min price

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

Frequent Visitor

## Re: Formula to sum all sales with Max and all sales with Min price

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

Announcements

#### Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors