Hello. I would like to create a calculated field in power pivot data model.

I have a row with values that I just want a distinct count (ignore duplicates) and then I have a row that has values or no values (and no duplicates). How can I create a column that counts up the unique values in the first column and divides by the count of the second column (excluding blank rows, I think excel counts blank rows). Thanks.