Sum of values filtered by a text column which starts with a given value

[Burner]

Hello everyone,

I'm new to powerbi and i'm try to figure out how to make some filters.

i have a table like this one here

Date	Number	Code	Description	Value
30/04/2018	160/00	40/00120	Company 1	185,93
30/04/2018	160/00	18/20/005	VAT	33,53
30/04/2018	160/00	66/20/005	goods1	152,40
30/04/2018	161/00	40/00300	Company2	25,00
30/04/2018	161/00	18/20/005	VAT	2,26
30/04/2018	161/00	68/05/325	Goods2	22,74
30/04/2018	162/00	40/00015	Company3	189,00
30/04/2018	162/00	18/20/005	VAT	24,09
30/04/2018	162/00	68/05/040	Service1	164,91

I want to summarize the column value filtered by the Code Column that stats with 40/

So i should have in return the sum of 185,93+25,00+189,00

Is there a way to do in dax funtion or should i create a conditional column and then summarize filtered by that new column?

thank you

[VasTg · Accepted solution]

@Burner 

Use this DAX.

Measure = CALCULATE(SUM('Table'[Value]),FILTER('Table',LEFT('Table'[Code],3)="40/"))

If it helps, mark it as a solution

Kudos are nice too.

[Burner]

@VasTg 

thank you

it worked, even if i had to change the last , with a ;

Measure = CALCULATE(SUM('Table'[Value]),FILTER('Table',LEFT('Table'[Code];3)="40/"))