How to filter le account numer begin with 6 or 7

[Orange2045]

Dear all,

we have balance account number begin with all the number from 1 to 9.

how can i filtre only the numbers begin with 6 and 7?

In the table, i choosed the format as Text.

Thank you for the help, 

b regards, 

Ariane

[NaveenGandhi · Accepted solution]

Hello @Orange2045 
Use the below Dax to create a column, You can user this as a filter.
Flag =
IF (
OR (
LEFT ( table[Bal_Account_No], 1 ) = "6",
LEFT ( table[Bal_Account_No], 1 ) = "7"
),
1,
0
)
Let me know if this helps!

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!