Forum Discussion
Perform Aggregations(SUM) with Condition where Code Column starts with a Certain value DAX
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 ...
Anonymous , 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") )
amitchandak
Super User
Super UserAnonymous , 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") )
Works Perfectly amitchandak