Forum Discussion
Solved
filter on visual interaction
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 " Va...
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 tryVariation CA =
VAR VentNet = [Vente Net]
RETURN
IF (
VentNet <> BLANK (),
DIVIDE (
VenteNet,
CALCULATE ( [Vente Net], DATEADD ( CALENDRIER[Date], -1, MONTH ) ),
2
)
)
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
)
)
thank you so much my friend, that works perfectly