How to filter numbers in Power BI

[lchoo]

Hello!

I'm trying to filter my very large data set (1M+ rows) by a wildcard number (a part of a GEOID) and not text, and I'm having a hard time. 

I used this measure: 

filter (<table name>, <column name> = "value*")

Any help is greatly appreciated.  I'm a complete beginner in all respects so giving me the answer in babysteps would be a amazing.

Thanks.

[lchoo]

Thanks.  Here's a sample from wordpad b/c the file is too large for Excel.  I'd like to filter the table by any first 5 numbers that I select, so from what I read to make it a wildcard, I would enter "XXXXX*" I think, but I'm not sure.  Many thanks for your help.

block_geoid,bsl_count,unit_count
010010201001000,9,9
010010201001001,20,27
010010201001002,17,20
010010201001003,12,12
010010201001006,1,1
010010201001010,2,3
010010201001012,13,14
010010201001014,44,61
010010201001015,17,18
010010201001017,23,26
010010201001018,16,18

[lchoo]

Thanks so much.  Sorry for being ignorant about this.  What expression do I use for the "calculate" above since I just want a filtered table by a wildcard number?  Also, if I want my value to be a wildcard, can I just use "value*"?

Thanks so much for your help. 

[smpa01]

Let's have some sample data and desired output based on the sample data before anything else.

[smpa01 · Accepted solution]

@lchoo  try this instaed

measure := calculate([__measure], FILTER(VALUES(tbl[columnToFIlter]), tbl[columnToFIlter]="value"))