filter on visual interaction

[Sofinobi]

helllo all,

please, i have two visuals that don't interact correctely, (a bar chart and a matrix), when i clic on the bar chart it doesn't filter on the matrix, it happens only with one measure " Variation CA", if i change the measure it filters correctly
may be the problem is from the measure ?!! 
th Measue calculates the variation of total sales by months: 

Variation CA =

    DIVIDE ( [Vente Net], CALCULATE ( [Vente Net], DATEADD ( CALENDRIER[Date], -1, MONTH ) ), 2 )-1

as in this image, when i clic in the bar chart Seller, i need to filter on the matrix to show only the Clients of that seller.
(the problem is not in the Edit interactions)

[tamerj1 · Accepted solution]

@Sofinobi 

Indeed. The -1 is creating a problem of forcing all rows to appear regardless of sny filter. That is simply because -1 cannot be filtered and will never be blank. 
Please try

Variation CA =
VAR VentNet = [Vente Net]
RETURN
IF (
VentNet <> BLANK (),
DIVIDE (
VenteNet,
CALCULATE ( [Vente Net], DATEADD ( CALENDRIER[Date], -1, MONTH ) ),
2
)
)

[Sofinobi]

thank you so much my friend, that works perfectly