Calculate with filter starts with and

[pedroccamaraDBI]

Hi guys
My table has an account column, from 10 till 90. My total measure is T Value.

I would like something like CALCULATE ( [T Value], FILTER [Account] = "4*" )
I want the sum of that measure but only the column account that starts with 4

I also would like something like CALCULATE ( [T Value], FILTER [Account] = "41", "53","25")
I want the sum of that measure but only the column account that are equal to 41, 53 and 25

Thanks in advance
Pedro

[amitchandak · Accepted solution]

@pedroccamaraDBI , Try like

CALCULATE ( [T Value],FILTER (Table,left(Table[Account],1) = "4" ))
CALCULATE ( [T Value],FILTER (Table,Table[Account] in {"41", "53","25"}))

[pedroccamaraDBI]

Awesome!!
Thank you so much @amitchandak