Remove blanks from a column

[Absalon29]

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

[tex628 · Accepted solution]

CashWt = IF([TotalWt] = BLANK() , BLANK() , 100 - [TotalWt])

[Absalon29]

Thanks, works perfectly!