Forum Discussion

Sofinobi's avatar
Sofinobi
Helper IV
2 years ago
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 " 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's avatar
    tamerj1
    2 years ago

    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
    )
    )

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    2 years ago

    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's avatar
      Sofinobi
      Helper IV
      2 years ago

      thank you so much my friend, that works perfectly