Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

measurement error

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...
Need Help
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

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"
    )
)