I have a measure in which I make a calcuclo and a treatment for when the value is null or blank and also applying a filter, the measure is as follows: 13th Salary = CALCULATE (IF (ISBLANK (CALCULATE...
Try simplifing your calculation using a calculated column from an IF statement. Create a column in the data where if it is blank it shows 1 and if it is not blank use 0.
Then, in your calculation filter by that condition.
