DAX/POWERPIVOT Count Number of Values That Contain Certain Text

[melq64]

Hi,

I've created this dax measure to count the number of values in a column that contain the text "PO BOX"

TotalPOBox:=COUNTROWS(FILTER('DistProfile v1-3',FIND("PO BOX",'DistProfile v1-3'[Dest_Address],,0)>0))

The formula works fine but the value returned (373) is less than the actual number of "PO BOX" values which should be (394).

Here's a sample of the column values in question:

PO BOX 300404
PO BOX 300712
PO BOX 106045
1 LINCOLN AVE
56 MARYLAND RD
33 LANCASTER RD
PO BOX 200453

I'm obviously missing something and would appreciate any assistance.


Thanks

 

[melq64]

I finally figured out the issue. The zipcode column didn't have the leading zeros in powerpivot data model hence the different count totals from the source data. Can't believe I missed that. Thank you once again for your help brawnystaff. Truly appreciate it