Issue with a sum if

[Tocosta]

I have a Column in power bi with a lot of serial numbers. I need a formula that count the serial number if starts with a specific number. This means count all the serial numbers that starts with 7. Counts all the serial numbers that start with 5. 
how can I do this?

[v-eqin-msft]

Hi @Tocosta ,

Could you tell me if your problem has been solved? If it is, kindly Accept a helpful reply as the solution to make the thread closed. More people will benefit from it.😀

Best Regards,
Eyelyn Qin

[AlexisOlson]

If your serial numbers are stored as text, then you could write something like

Count5 = COUNTROWS ( FILTER ( Table1, LEFT ( Table1[SerialNo] ) = "5" ) )

[jdbuchanan71 · Accepted solution]

@Tocosta 

Try something like this.

7 Serial Count = CALCULATE(COUNTROWS(YourTable),LEFT(YourTable[Serial Number],1)="7")