Forum Discussion

citr10's avatar
citr10
New Member
2 years ago

Filtering

Hello. I need help about using two date slicers in one table. I have 2 table. First table include date, product, quantity. Second table include date and id. So I want to show all product and their relevant sum of quantities on matrix table with 2 date selection. But problem is that when I select first date and then second date, it's only shows products selected at first date. I'll appreciate your help. P.S. Screenshots atached.

 

4 Replies

  • Dangar332's avatar
    Dangar332
    Resident Rockstar

    HI, citr10 

    use edit interaction  feature refer HERE 

    use edit interaction bw your both slicer so not interact with each other

     

    • citr10's avatar
      citr10
      New Member

      I already did it. I think problem is in measures.  

      • Dangar332's avatar
        Dangar332
        Resident Rockstar

        hi, citr10 
        try to remove ALL() function from both measure

        use only sum(product[quantity])

  • Maybe a open door, but why are you trying to do this and not using one date table with one date slicer?