Need help for production dashboard

[Emranit]

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 with different digit,
III) Another is starting with SP

My requirement is which dyelot is start with 1A ans SP. Those will not show in Dyelot list. Dyelot picture list indicate with red color.

2)
Depends on RunTime in Minutes, showing the Bulk_Production value. If the RunTime in Minutes is maximum time 900, showing the Bulk_production is 0.

Here my requirement is, those Bulk_Production is 0, these types of columns are no required. Like as Dyelot, Bulk_Production, RunTime in Minutes and EndTime. Not required columns indicate with green color.

https://drive.google.com/file/d/1ZeQyFOSR-MdBBzXJtFaU43jJq5QGXABb/view?usp=drive_link 

https://docs.google.com/spreadsheets/d/1Ueu3dHSIjVglWfO0kSY7P0z9QP6K8gd1/edit?usp=drive_link&ouid=11... 

Advance thanks for your quick initiative.

[Emranit]

Sorry for that, Access allowed, Please proceed

[lbendlin]

[Omid_Motamedise]

Please edit the access to the file

[lbendlin]

Access denied - please check.