Forum Discussion
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...
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"
)
)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.
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)
