Perform Aggregations(SUM) with Condition where Code Column starts with a Certain value DAX

[Datagulf]

This is data as close to the following.

Itemcode		Items		Value
41000		Item A		230000
41001		Item B		266000
41002		Item C		340000
41003		Item D		120000
41004		Item E		560000
41005		Item F		901000
51000		Item G		459000
51001		Item H		341000
51002		Item I		100000
51003		Item J		230000
51004		Item K		231400

So I would like to do a SUM of items Value where the ItemsCode startwith 41 in the Itemcode and another SUM of items Value starts with 51. 
Assist.

[amitchandak · Accepted solution]

@Datagulf , You can create measure like

calculate(Sum(Table[Value]), filter(Table,left(Table[ItemCOde],2) = "41") )

or

calculate(Sum(Table[Value]), filter(Table,left(Table[ItemCOde],2) = "51") )

[Datagulf]

Works Perfectly @amitchandak