Measure to add pieces of a product in multiple locations

[Syndicate_Admin]

Hello everyone:

I hope you can help me in the following. I need a measurement that can make the sum of the quantities of the same product that is in several locations, these locations are from A to Z and could be both in one and 10, for example.

Thank you very much for the attention and support.

Product Name	Quantity	Location	Comment
Product 1	40	90
Product 4	120	50
Product 4	13,070	A	Add these amounts, total: 13,300
Product 4	40	A
Product 4	90	B
Product 4	100	D
Product 5	80	40
Product 5	150	C	Add these amounts, total: 210
Product 5	40	W
Product 5	15	E
Product 5	5	Y

[Syndicate_Admin]

Thank you very much for the contribution, I thought that I had to put a range: "A" to "Z".

Best regards.!!

[lbendlin]

seems to be straightforward. What have you tried and where are you stuck?

[Syndicate_Admin]

I'm honestly new to the DAX language, I've done some measurements and they're simple. Where I'm stuck is that I don't know how to indicate that I add by range of "location" that are letters (A --> Z) and that I do NOT take into account the "locations" that are numbers.

Grateful for the support they give us.

[lbendlin]

None of the locations are numbers, they are all text strings. Filter by the first character of the location being greater than "9" ( or greater than/equal to "A")