Remove blanks from a column

I am trying to calculate portfolio cash weight. The portfolio always has a percentage which is not invested and therefore doesn't sum to 100%. I have a measure which calculates this cash weight (CashWt = 100 - TotalWt). When I put the CashWt into the slicer it includes dates where there is no data. How can I remove those dates from the report. I want to be able to write a dax measure and not to use filters