Create slider based sum of quantity for criteria

[Kpetersen92]

I am trying to create a slider based on the sum of quantity by customer. Or to at least be able to select a specification such as <500 total sales. I want it to be continually updating with the additional filtering from other slicers that has been applied. 

The data is rows showing specific orders, currently can only get it to filter based on quantites per order. However, need to filter it by total quantity relevant to the other filters applied.

Customer	Quantity
A	5
B	10
B	15
B	6
A	8
A	7
C	5
C	6
C	8

Is there a way to easily make this? I tried making a measure for the sum by customer, but it won't apply to the slider.

Thanks!

[Kpetersen92]

Hello Amit, Thank you for your reply.

I tried creating the measure using the code you provided, but receive the following error.

Quantity total for Customer 2 =

    SUMX(ALLSELECTED('Shipment Level Data','Shipment Level Data'[Customer] = MAX('Shipment Level Data'[Customer]) && 'Shipment Level Data'[Unique Shipment] <= Max('Shipment Level Data'[Unique Shipment])), [Quantity])

Error: Multiple arguments are not allowed in the ALLSELECTED function when the first argument is a table reference.

[amitchandak]

@Kpetersen92 , Create a measure

m1 = sumx(allselected( Table, Table[Customer] = max(Table[Customer]) && Table[Order No] <= Max(Table[Order No]) ), [Quantity])

Have a numeric parameter say name is limit you will get measure say [Limit value]

Then have a measure like

if([M1] <= [Limit value] , [M1], blank())

or

Sumx(summarize(Table, Table[Customer], Table[Order no]) ,if([M1] <= [Limit value] , [M1], blank())  )