Dax expression for distinct counts with a conditional element

I need help with a specific problem.  I am extracting data from a dynamic spreadsheet which gets regular feeds for updates and additions in terms of rows. I have 5 specific Columns – Openings Rema...