Count ID's from text

[andrius_pfa]

Hello, Im new to Power Bi , and I need help. I want to create column and count how many ID's begins with _A.

Example:

ing-WoX8/1/1_A1385556-Xdu Trou6_A1407390-Maon - 2
S5/1/1_A1385448-VALENANI - 1
tton Bld-1KN/5_A1400101-FONth/2/1_A1428673-GIANSSI_A153748 - 3

thank you!

[Anonymous · Accepted solution]

Hi @andrius_pfa ,
you can use this formula for creating this column.

_A count = 
VAR Search_string = "_A"
RETURN
DIVIDE(
    LEN('Table'[Value]) - LEN(SUBSTITUTE('Table'[Value],Search_string,BLANK())),
    LEN(Search_string),
    0
)

Regards