MoM measure displaying -100% when value is not present for this month as well as current month

[aJ2]

Hi.

I have created a MoM measure-

1. sessions_MoM = SUM(all_traffic[sessions]) / [sessions_PM] - 1

2. sessions_PM_all = CALCULATE(SUM(all_traffic[sessions]), PREVIOUSMONTH('date'[date_key]))

The first image is the one where a filter is applied and the second image is the one where no filter is applied. 

One possible solution is that I can create a visual filter to exclude the ones where the value is -1. But I want some workaround so that there is no need to use the visual filter.

Kindly guide.

[Floriankx · Accepted solution]

Maybe you can modify your Measure:

sessions_MoM = 
VAR MoM=SUM(all_traffic[sessions]) / [sessions_PM] - 1
RETURN
IF ([MoM]=0,BLANK(),[Mom])

[aJ2]

Thank you so much