ISSUE WITH DIVIDE -1

[CESARPULIDOGDL]

HI EVERYBODY

I HAVE A ISSUE, WHEN I USE A MEASURE THAT DIVIDE MONTH EXPENSE VS MONTH EXPENSE PREVIOUS YEAR & USE -1, THE VISUAL, HAVE A ISSUE THAT SHOW ME OTHERS YEARS THAT I HAVENT SELECTED IN THE SLICER DATE.

IN THE IMAGE, I CAN EXPLAIN BETTER, THE QUESTION IS HOW CAN I USE DE -1 AND DONT LOSS THE SLICER DATE.

REGARDS

[Anand24 · Accepted solution]

@CESARPULIDOGDL ,
The issue seems to be that some results are evaluating to -1 instead of blank.
Try the below measure:

#med gasto promedio AAvsYTD = 
IF ( 
([#med gasto mensual]/[#med gasto mensual promedio AA]) - 1 = -1,
BLANK(),
([#med gasto mensual]/[#med gasto mensual promedio AA]) - 1
)

[CESARPULIDOGDL]

thanks it really works 😁

[CESARPULIDOGDL]

Thanks, let me try, i will return.