Need help with a partitioned sum slicer that updates based on other slicer selections

[plutoforever]

I am not sure why this is such a struggle for me to figure out but I have a product gallons detail table with these 5 columns: 

And 4 slicers: 

Sales Volume in the table is broken out by Account #, G/L Date and Product Type however Summed by Account # is a calculated column partitioned just by Account #: 

Summed by Account # = 
    CALCULATE(
        SUM('Gallons Purchased Details'[Sales Volume]),
        FILTER(
            'Gallons Purchased Details',
            'Gallons Purchased Details'[Account #]= EARLIER('Gallons Purchased Details'[Account #])
            )   
)

The problem is being a calculated column it doesn't update on slicer selections and I need it to for the Summef by Account # slicer.  For example, for the last 12 months the total Sales Volume for Account # 519981 is 1,105.00 and for 3818608 it's 1,531.00: 

Which is what shows in the slicer: 

However, say the G/L Date Slicer is changed to this: 

 

I would want the Summed by Account # slicer to update and show a minimum of 800.00 and maximum of 1,084.00 

 

The end result being so the user can only show accounts that have bought a certain amount of product over a specific date range and/or product type.

This is the raw data: 

Account #	Sales Volume	G/L Date	Product Type
3818608	7	12/28/2021	Gas
3818608	15	12/29/2021	Gas
3818608	6	1/3/2022	Gas
3818608	17	1/4/2022	Gas
3818608	16	1/6/2022	Gas
3818608	21	1/10/2022	Gas
3818608	15	1/12/2022	Gas
3818608	16	1/16/2022	Gas
3818608	16	1/18/2022	Gas
3818608	40	1/25/2022	Gas
3818608	17	1/31/2022	Gas
3818608	17	2/2/2022	Gas
3818608	9	2/4/2022	Gas
3818608	17	2/8/2022	Gas
3818608	16	2/13/2022	Gas
3818608	17	2/20/2022	Gas
3818608	7	2/23/2022	Gas
3818608	17	2/25/2022	Gas
3818608	30	3/2/2022	Gas
3818608	10	3/6/2022	Gas
3818608	12	3/9/2022	Gas
3818608	13	3/12/2022	Gas
3818608	12	3/18/2022	Gas
3818608	16	3/21/2022	Gas
3818608	15	3/25/2022	Gas
3818608	28	3/27/2022	Gas
3818608	25	3/30/2022	Gas
3818608	19	4/3/2022	Gas
3818608	17	4/4/2022	Gas
3818608	10	4/5/2022	Gas
3818608	16	4/7/2022	Gas
3818608	11	4/10/2022	Gas
3818608	27	4/14/2022	Gas
3818608	20	4/18/2022	Gas
3818608	13	4/20/2022	Gas
3818608	14	4/21/2022	Gas
3818608	7	4/24/2022	Gas
3818608	16	4/25/2022	Gas
3818608	14	4/29/2022	Gas
3818608	12	4/30/2022	Gas
3818608	5	5/4/2022	Diesel
3818608	36	5/6/2022	Gas
3818608	15	5/8/2022	Gas
3818608	17	5/9/2022	Gas
3818608	12	5/12/2022	Gas
3818608	28	5/17/2022	Gas
3818608	12	5/22/2022	Gas
3818608	16	5/23/2022	Gas
3818608	12	5/25/2022	Gas
3818608	48	5/29/2022	Gas
3818608	41	6/5/2022	Gas
3818608	22	6/8/2022	Gas
3818608	10	6/16/2022	Gas
3818608	36	6/17/2022	Gas
3818608	13	6/20/2022	Gas
3818608	9	6/21/2022	Gas
3818608	15	6/24/2022	Gas
3818608	10	6/26/2022	Gas
3818608	15	6/29/2022	Gas
3818608	14	7/2/2022	Gas
3818608	15	7/3/2022	Gas
3818608	6	7/4/2022	Diesel
3818608	4	7/5/2022	Diesel
3818608	13	7/5/2022	Gas
3818608	34	7/10/2022	Gas
3818608	10	7/17/2022	Gas
3818608	15	7/20/2022	Gas
3818608	8	7/24/2022	Gas
3818608	22	7/26/2022	Gas
3818608	30	7/31/2022	Gas
3818608	9	8/2/2022	Gas
3818608	14	8/7/2022	Gas
3818608	14	8/13/2022	Gas
3818608	11	8/16/2022	Gas
3818608	20	8/25/2022	Gas
3818608	14	8/31/2022	Gas
3818608	10	9/4/2022	Gas
3818608	16	9/9/2022	Gas
3818608	8	9/11/2022	Gas
3818608	13	9/13/2022	Gas
3818608	22	9/18/2022	Gas
3818608	21	9/28/2022	Gas
3818608	4	10/2/2022	Gas
3818608	10	10/3/2022	Gas
3818608	17	10/6/2022	Gas
3818608	28	10/9/2022	Gas
3818608	14	10/14/2022	Gas
3818608	20	10/22/2022	Gas
3818608	15	10/23/2022	Gas
3818608	11	10/28/2022	Gas
3818608	15	10/31/2022	Gas
3818608	11	11/4/2022	Gas
3818608	14	11/13/2022	Gas
3818608	14	11/16/2022	Gas
519981	100	1/4/2022	Diesel
519981	108	2/24/2022	Diesel
519981	97	2/24/2022	Gas
519981	274	6/16/2022	Diesel
519981	298	8/29/2022	Diesel
519981	228	11/16/2022	Diesel

[FreemanZ]

Calculated column/table is not supposed to respond to the slicer or any other filtering action in Report view.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculated-columns-and-slicer-value/m-p/22654...

[plutoforever]

Yeah I know a calculated column can't update which I'm trying to find an alternate solution.  I followed your link but am struggling to apply the solutions there to what I am needing.  The end result is a measure and I can't use that in a measure. 

I am needing an end result where the user can slice by sales volume only after G/L Date/Product Type are selected. So for example: 1) Let them show all customers who purchased at least 200 gallons of Propane in the past calendar year or 2) Let them show all customers who purchased 200 gallons of all products for last month.  So I need to start with the product and date details so the user can slice by them but then end with a total sum slicer once the selections have been.

[plutoforever]

Also I can create a measure that gets me the data results I need just can't use a measure in a slicer.