DAX to count based wild card search

[Seer_Bug]

Hi All, 

Data looks like this :

Audit ID	Emp Name	Frontline Failuers
1	ABC	Credit not offered
2	DEF	Did not approach their Manager;System Probing;Reconfirming
3	EFR	No Failure
4	TGR	Lack of Authorisation
5	RUJ	Objection handling;System Probing
6	IKU	Did not approach their Manager
7	OLJ	System Probing
8	OLI	Credit not offered;Objection handling
9	TGR	Lack of Authorisation

looking for a result like this using DAX :

Frontline Failures	Count
Credit not offered	2
Did not approach their Manager	2
No Failure	1
Lack of Authorisation	2
Objection handling	2
Did not approach their Manager	2
System Probing	3

Thanks

[Payeras_BI · Accepted solution]

Hi @Seer_Bug ,

COUNT CONTAINSSTRING =
CALCULATE (
    COUNT ( 'Table'[Frontline Failuers] ),
    FILTER (
        ALL ( 'Table'[Frontline Failuers] ),
        CONTAINSSTRING (
            'Table'[Frontline Failuers],
            SELECTEDVALUE ( 'Search'[Frontline Failures] )
        )
    )
)