Count with if conditions in Dax (Wildcard match )

[Anonymous]

Hi Team,

Could you please provide me the solution on below condition in Dax.  I wanted to apply one excel formula which was writen in excel -

Countif in excel e.g =COUNTIF([Value],[@Value]&".*")

Below is the requirement.

 

[HotChilli · Accepted solution]

I don't get the same results as you but here's the DAX

ColumnNew = VAR _searchstring = TableY[Val] & "."
RETURN
   COUNTROWS(FILTER(TableY, SEARCH(_searchstring, TableY[Val],1,0)  )) + 0

Example of extra count   :   count of "1." is 3           but I get 4  because  4.1.1  contains 1.