measurement error

[Anonymous]

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 (sum (FTEGRH_ItemServidor [vlvalor]); Tipo_evento [type] = "13th salary")); 0; CALCULATE (sum (FTEGRH_ItemServidor [vlvalor]); Tipo_evento [type] = "13th Salary")))

when I do not use the condition ISBLANK values are presented smoothly despite showing in brnaco some but to apply the function ISBLANK the report missed the filter featuring all zero values, what I'm missing?

[Sean]

@Anonymous Try without the first CALCULATE

13th Salary =
IF (
    ISBLANK (
        CALCULATE (
            SUM ( FTEGRH_ItemServidor[vlvalor] );
            Tipo_evento[type] = "13th salary"
        )
    );
    0;
    CALCULATE (
        SUM ( FTEGRH_ItemServidor[vlvalor] );
        Tipo_evento[type] = "13th Salary"
    )
)

[Anonymous]

@Sean

the same thing happens

[Sean]

@Anonymous Okay I think you just don't want those included in your report (because I don't see an error)

I think in this case you'll be better off using the Visual Level Filter

Change your Measure to only this

13th Salary =
CALCULATE (
    SUM ( FTEGRH_ItemServidor[vlvalor] );
    Tipo_evento[type] = "13th Salary"
)

Then go to the Visual Level Filter

select the 13th Salary Measure => Show items when the value: => select is not blank => hit Apply Filter

EDIT: You could also add "AND is not zero" like in the picture below (if appropriate)

[Anonymous]

@Sean @kcantor

not yet decided when I applied the rules cited no filter started to work on the chart

[kcantor]

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.