topic Re: Count with if conditions in Dax (Wildcard match ) in DAX Commands and Tips

Count with if conditions in Dax (Wildcard match )

Anonymous — Tue, 09 Jun 2020 13:10:55 GMT

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 — Tue, 09 Jun 2020 17:17:33 GMT

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.