DAX measure to check Name column for Numbers and Special Characters

[Anonymous]

This has to be a DAX measure since working in a live connection model.

How to find and count any rows with a Number or special character in the Name Column. This would be a straight forward ISNONTEXT in a calculated column. Stuck on how to solve as a dax measure. 

thanks.

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format?

[Anonymous]

@amitchandak  Simple data quality check on Name field for no numbers and special characters. Count all TRUE in a KPI card. All of this using DAX measures only. thanks

ID	Name	Validation Check
1	"Dan"	TRUE
2	101022	TRUE
3	28392-3-3	TRUE
4	Joe Bloggs	FALSE

[amitchandak]

@Anonymous , refer if this video can help

https://www.youtube.com/watch?v=9sKeZbfzBTk

[Anonymous]

This method will not work. I am using a live connection to SSAS and the data team are not avaiable. I have no access to amend tables or add them. I can only use DAX MEASURES.