So I have an issue where a target field is populated before the sales data arrives at the start of the month. This is skewing my results. In a table this isn't too much of a problem because you can just filter out the row using 'is not blank' tick box and it will re-calculate the data.
My question is about the measures which I drop into cards. How do you stop it counting the blank rows? If the Sales MTD column/row is blank, I don't want it to add in values from the budget or variance columns into my measures either. This is my DAX: