Forum Discussion
Anonymous
10 years agoNot applicable
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...
Sean
10 years agoCommunity Champion
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)