Need help for production dashboard

In the power BI, some DAX implemented as my requirement. Actual Dashboard connected from SQL database. 1) In Dyelot, there are 3 types of no. I) One is starting with 1A, II) Another is starting w...